I have a table in a database that contains fields for first name, last name, session start (date & time) and session end (date & time). I need a query that will display just the most recent session start details for each person - each person has multiple entries in the table. It sounds as though it should be straight forward, but I can't get anything to work. Can anyone help please?
Your tables are set up incorrectly. You should have one for each person with a one to many relationship to a session table containing start and end sessions. Set up the relationship in the relationship window and enforece referntial integrity. Then you can set up a query using both tables. Under "SessionStart" or whatever you call the field, you can put "Max(SessionStart") into the criteria line. Until you'get your people out into a table of their own it will not work but you can easily use queries to do this for you.
This thread is now locked and can not be replied to.