Top item

[Guest]

I have a query that returns all the products ordereded. This includes the
product name/id, the order date, and the customer number/name. I then do
some math to decide if the customer is due to reorder the product in the next
60 days and if so, I display it on my report.

BUT... if the customer ordered in April and then ordered again in May, the
April order is still showing up as due.

How can I modify my report so that I only see the latest order for any given
client/product combination?

I tried making a combined field inmy query, tried unique records, unique
values, I tried using TOP and MAX. I'm sure I'm on the right track, but
Idon't think my fields are in the right order for the appropriate option to
work propery.

Thanks!!!!

 

[Michel Walsh]

Hi,


Take a look at http://www.mvps.org/access/queries/qry0020.htm



Hoping it may help,
Vanderghast, Access MVP