markedback
MIS
I have a query based on a table that has multiple entries for same PK differentiated by sequence number of the entries and date-times.
I am trying to pick the entries with the last (latest) date only, for the purpose of my query but it keeps picking all the entries.
I have tried Max, Last, DMax And Unique values on both the sequence number and date fields (one at a time and both at a time) but the problem persists.
Please help me with a condition I can enter in the criteria field of the query under date, which picks a single entry for each PK based by the latest date.
Thanks in advance.
-Mark.
I am trying to pick the entries with the last (latest) date only, for the purpose of my query but it keeps picking all the entries.
I have tried Max, Last, DMax And Unique values on both the sequence number and date fields (one at a time and both at a time) but the problem persists.
Please help me with a condition I can enter in the criteria field of the query under date, which picks a single entry for each PK based by the latest date.
Thanks in advance.
-Mark.