I am trying to make only the most up to date records display in a form for all the contact names in my DB based on Date.
If there are 4 records with the same contact name in my database the query that loads the data into a form will need to do the following:
1) search the 4 records for the most recently added/updated record based on the date field.
2) Pull the found resulting record into the form.
This procedure must be repeated with all the records in the database until a complete list of only the most up to date records of contacts are loaded into the form.
I have been trying this and I cant seem to make it work - does anyone have any ideas?
Thanks for your help!