Date Query

Topic

New Reply

Hello,
I have a table that users are entering templates defining certain characteristics of a product. At different times, these characteristics change, so the users are entering a new line, with the same product, but different characteristics, so I can track the changes (I have a field that automatically enters the date the record was added).
I need to create a query that will select the most recent record for a given product and am having trouble. I’ve tried grouping by product and displaying the “last” date, but I can’t get it to work, it shows all records.
Can someone help me set this up?

Thanks,
DRA

Reply | Quote

Replies

When you say the users are entering a new “line”, do you mean a new record? If so, and the Date Added field is Date/Time type, try using a Totals query, grouping on Product and using the Max function on Totals row for the Date Added field.

Reply | Quote