query for Duplicates

[Payal Patel]

Hi,
I'm trying to run a query as such:
I have a table with socials that are entered multiple times because that's the number of days worked and then sometimes the social is entered once cause the employee started working the last day of the pay period for examplethis is how the table looks:
Worker 1
Date SSN Hours Worked
2/26/2010 123 8
2/27/2010 123 8
2/28/2010 123 8
3/01/2010 123 8

worker 2
Date SSN Hours worked
3/01/2010 456 8
Is there a query that will flag the socials that are entered more than one time vs. being entered one time only?

I thinks it's some kind of count query but i'm not 100% sure.
thanks,
P.

 

[gemma-the-husky]

yep

do a totals query

group by socials

put socials in the query again, but this time put count, and in criteria put >1
(doesnt have to be socials - it can be anything)

this will show you soc security values that occur more than once