Prev: Continuous Form Loading Problem
Next: Joined table: Returns duplicated record
From: tonyrulesyall on 26 Jun 2008 20:47
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?
From: Rob Parker on 26 Jun 2008 21:10
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

tonyrulesyall(a)yahoo.com wrote:
> 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?

 | 
Pages: 1
Prev: Continuous Form Loading Problem
Next: Joined table: Returns duplicated record