How to filter the row that contains the more recent date and make it part of a form?

[hesca]

Hello experts.

I need to filter rows from a purchases table, and only show one for every customer, the exact one for their latest purchase. I later need to include these rows on a tabular form so I can color code them by date using conditional formatting.

How do I do this? How do I design a query that selects all the rows that meet these two criteria:



1. Customer name (no duplicates)
2. Purchase date (latest purchase from this customer)

Any pointers are greatly appreciated

[pbaldy]

This should help:

http://www.baldyweb.com/LastValue.htm