queries for duplicates and max date

  • Thread starter Thread starter opeyemi1
  • Start date Start date
O

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
 
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.
 
Back
Top