Query to search out records with duplicate field

[RnRExpress]

I am sure it can be done <G>.

I was trying to create a query which will look at a specific text field and show on the query those records.

Is there a simple way that this can be done?? Also, this tex field is always an 11 digit number, if that matters.

Thanks in advance,

Richard

 

[PHV]

Can you please be more specific ?
What is the schema of the table(s), input samples and expected result ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[RnRExpress]

PHV,

What I do is repair work, and I track every item I look at.

Each item is based on a serial number, which is 11 numbers long, and is entered into a text field on my database.

What I am trying to do, is run a query so that it looks at this serial number field, and check to see if there are duplicate entries of that one serial number. In essence, I am trying to see how any times a particular serial number has been worked on.

So, in other words, I have the same serial number entered on three separate records. I want to be able to run either a query showing me these three records.

Once I can get this done, I can then finese the report or query layout to show the info I need from each record.

thanks again!

 

[RnRExpress]

PHV,

Well, I never realized this, but the Query wizard has the duplicate thing built in. Sorry to have wasted your time on this one.

Richard