Duplicate query acrros 4 fields

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.
 
N

Nogger-01

I am working within access i have a table were i paste i the data witch
consits of the following collums.

Journey Number Revenue Number Board Number Duty Numbers
1045 12 1101
1101
1045 12 1101
1101
1045 12 1101
1136
1081 12 1101
1136
1081 12 1101
1118
1117 12 1101
1118

i need to create a qury that will search against the first two colums and
show the duplicates. But once the duplicates have been sorted within the
first two collums i then need within the same query for it to cros refrance
the information

so the collums i need to match are the first two but in the same query i
need to find based on the duplicates were board number and duty number dont
match with the Journey number and Revenue number.

Thanks.
 
J

Jeff Boyce

Based on your description, you may be working in a spreadsheet. If you are
using Microsoft Access, please explain a bit more what YOU mean by these
field names (i.e., what kind of data are you storing? we aren't there, we
don't know your business...).

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
J

Jeff Boyce

I still don't have any idea what a "Journey Number" or a "Revenue Number"
is.

I can't tell from your description whether you are trying to find duplicates
BETWEEN the first two columns (none in your example), or WITHIN each of the
first two columns (all are duplicate "Revenue Number", some are duplicate
"Journey Number").

I don't understand what you mean by "sorted" or by "cross-reference".

I'm not sure why you have decided that what you are trying to do must be
done within a single query... you can "chain" queries together to accomplish
more complex tasks than you might be able to do with a single query.

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top