Software

Ask something
Discussion Locked

MS ACCESS'97 FIELD QUERY

0 helpful
3 replies

by mozster

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have an Access'97 database which contains the following fields: NAME, DATE.

There are multiple records in the database for the same name but a different date each time so one person may have 10 records (using the same name) but each record willhave a different entry in the date field.

Do you know which query/argument/function I can use if I just want to pull out the records with the most recent date on them?
i.e. the most recent record for that person.

3 replies

by sheryl v

Do a regular query with that table, then in design view, under the view menu, click on "Totals", this adds another line to the query grid, leave the name field as "GROUP BY" in the TOTAL line and change the Date fields TOTAL line to MAX. THis should give you the results you want!

Good Luck!

This discussion is closed to new replies.