Duplicate query across 4 fields.

  • Thread starter Thread starter Nogger-01
  • Start date Start date
N

Nogger-01

Hi

I have been trying to create a query that will find the duplicates accross
and number of fields to bring back the values that need checking for example.

I have a table with the following fields

Journey numbers, Revenue Numbers, Board Numbers, and duty numbers.

i need help with a query that will bring back the matching values in the
journey numbers and revenue numbers field. then were once the journey number
and revenue nuimber match the board number doesnt match.

Sorry new to all this.

Thanks.
 
Have you tried using the query wizard? It has an option to create a Find
Duplicates query and will allow you to define duplicates using multiple fields.



John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
Have thried that.

the quary i need to to cross refrance two colums to match with duplicate
data then were they match need the third colum to not match the previous two
that we have duplicates in .

have tried useing the folloing in the first two colums

In (SELECT [Journey Number] FROM [Table1] As Tmp GROUP BY [Journey
Number],[Revenue Number] HAVING Count(*)>1 And [Revenue Number] =
[Table1].[Revenue Number])
 
Back
Top