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.

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