What can I put in my query to show that a field bein duplicated

G

Guest

What can I use in my query to warn a data entry person that they are keying
in a
duplicate record.


Thanks,

Big Mike
 
J

John Spencer

There is nothing you can put in the query that will do this. If you are
using forms to control input (which you should be) then you can use VBA code
to check.

How many fields are involved in determining that the record is a duplicate
record? At what point do you want to determine the person is entering a
duplicate record? What do you want to do if the record is a duplicate?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine Duplicates in Query 0
Access Auto Matching Duplicates? 0
Append Query Issue 0
Query to duplicate a record with one field updated 0
Deleting Duplicates 1
challenging query 3
Duplicates in union query 3
Query based on Query 1

Top