Access Query: get first date field

T

tonyrulesyall

I am using Access XP.

I am working with a database with many file numbers.

Each file number has multiple paid dates.

How do I get the query to pull each unique file number, and then
just the most recent paid date for that file number?
 
R

Rob Parker

Use a totals query. Group by FileNumber, and select Max for PaidDate. The
SQL will be something like:

SELECT YourTableName.FileNumber, Max(YourTableName.PaidDate) AS
MostRecentPaid
FROM YourTableName
GROUP BY YourTableName.FileNumber;

HTH,

Rob
 
Top