checking records

[Linda1234]

Hi,



I have a query displays all the paking results.

I need to check if the name field in first record is equal to the name in the second record or third record ... same as the date field. if they are equal, I will update another column to mark it. We only charge once in one day, it does not matter how many times you are in/out.

anyone please help me.

thanks,
Linda

[June7]

You could view the records on a form and then mark as appropriate.

Otherwise, use code to count records to determine if the value exists more than once. Can use DCount function. Having code do the update for you is tricky.

[ssanfu]

What about using the "Find duplicates" query wizard??

[June7]

I think only one table is involved.

[ssanfu]

Hmmmm. I did a test with the find duplicates wizard using one table..... seemed to work. Tried with one field, then with two fields... seemed to work.
Should work with Name and date fields (Name and date are bad field names if they are in fact the field names. "Name" and "Date" are reserved words in Access)