queries for duplicates and max date

[opeyemi1]

Hello All:

Say I have a table in excel.

The first column (column A) is made up of another column (E) and a bil
date (column F) i.e. E1&F1. The second column (column B) is made up o
column E and due date (column G) i.e. E1&G1.

Sometimes the records in column A repeat, but the entries in column
are always different.

E.g.
bayview03/23/2003 bayview03/27/2003
bayview03/23/2003 bayview03/28/2003
bayview03/23/2003 bayview03/30/2003
allen03/05/2003 allen03/07/2003
allen03/05/2003 allen03/09/2003
allen03/05/2003 allen03/10/2003
allen03/05/2003 allen03/11/2003
allen03/05/2003 allen03/15/2003
yonge03/02/2003 yonge03/02/2003
yonge03/02/2003 yonge03/12/2003
yonge03/02/2003 yonge03/21/2003

I want my second query to give me the following:
bayview03/23/2003 bayview03/30/2003
allen03/05/2003 allen03/15/2003
yonge03/02/2003 yonge03/21/2003

i.e. I want the query to give me the latest date in column B.


Thanks for your kind help


Opeyemi

 

[Steve Schapel]

Opeyemi1,

If you are using the Access query design view, put both Column A and
Column B in the query. Make it a Totals Query (select Totals from the
View menu). In the Totals row of the query design grid, leave Group By
in the Column A column, and put Max in the Column B column.