andrewhh82
MIS
Hi, and thanks.
i have a table with 3 fields Sku #'s, a date, and a price for that sku. i also have a list of sku's i need to pull and 2 dates that i need to know the price for. Example: what is the price of sku# 10002 on 12/1/04 and 12/1/05. I need this returned all on the same row. I have around 150 sku's so i thought i should build a table with all the sku's and the two dates for each sku. Then somehow query this against my initial table. Does this make sense? If anyone could help, that would be great. I'm working in access 97.
i have a table with 3 fields Sku #'s, a date, and a price for that sku. i also have a list of sku's i need to pull and 2 dates that i need to know the price for. Example: what is the price of sku# 10002 on 12/1/04 and 12/1/05. I need this returned all on the same row. I have around 150 sku's so i thought i should build a table with all the sku's and the two dates for each sku. Then somehow query this against my initial table. Does this make sense? If anyone could help, that would be great. I'm working in access 97.