Latest date

[captnk]

I need to be able to query my table for the "Last/Latest Date" on which a product was used.
The table has [productname][date].
There is therfore an entry for each date the product was actioned.
Just cant seem to get the syntax right in the query criteria to pull the right date.

 

[Rich]

Look up the Max function, if you perform a search here this question has been answered many times, most recently by Pat Hartman.