Recent content by Veronka

I have run the Query which is great but this just lists all the duplicates. I actually wanted any previous claims to pop up somewhere in a new field in the actual table. Let's say I enter a new claim with the serial number 123456 in a serial number column in my table and soon as I tab away, a...

Thank you, I'll will give it a go.

Hi, Hope somebody can help. I want to have the ability to check for duplicate entries - if duplicate, I want all the duplicates to display(list) in a new field. This is a warranty database and I'd like to see all the previous issues (claim ID's) relating to certain serial number. I'm very new...