HELP!!!!

  • Thread starter Thread starter mac
  • Start date Start date
M

mac

My boss gave me a project and I am not sure how at get the answers he wants.
I have a database that has over 150,000 products and the date the products
changed prices. Item # - Products - Quanity - Price per unit. .
I want to get the price closest to the date the product was
shipped if it changed in 2007, if not the lastest date it changed. Any help
would be greatly appreciated.
 
Hi Mac,

this question is also posted in microsoft.public.access.queries ...
please do not post the same question to multiple groups, thank you

Warm Regards,
Crystal

*
(: have an awesome day :)
*
 
Back
Top