Solved: Find duplicate numbers

[GaryB]

Hi,

I know this is basic stuff, but honestly, my mind is blank. I have a table with a column called , jobid. It is an editable field and I need to find any duplicate numbers that have been entered. Can anyone give me a suggestion on the best way to do this.

Thanks

Gary

[OBP]

You need to use a "find Duplicates" query. To create one go to the queries section and on the queries menu click on the "New" tab and select the Find Duplicates from the drop down list and follow the Wizard.

[ALe]

I'm not sure it's what you're looking for. If you need to find values that are duplicates then copy this in the SQL statement of a query and substitute TableName with the name of your table

SELECT TableName.jobid, Count(TableName.Jobid) AS NumberDuplicates
FROM TableName
GROUP BY TableName.jobid
HAVING (((Count(TableName.jobid))>1));

[GaryB]

Thanks to everyone. The " find duplicates" query did the trick. I knew it was something simple. Thanks again

Gary