I have a data base with multable names each name has multiple entries not all the same date I would like to be able to extract the latest record for all names
I have a data base with multable names each name has multiple entries not all the same date I would like to be able to extract the latest record for all names
Q1, get the latest index for each. In the query turn on summation (grouping)
select userID, Max(Date) from table
then make Q2, using Q1 to see all the fields:
select * from table,Q1 where table.UserID = Q1.UserID and table.Date = Q1.Date
Do an aggregate query by clicking the Totals button in the ribbon and include the ID field, name and other required fields.
All fields will have Group By in the Totals row
Change that to Max for the ID field if it's a number field.
Otherwise use Max for the date field used in your query
Thanks very much it works perfect once I manipulated the information I wanted many thanks