Records will not append to another table due to Key violations and

B

BruceM

You could put = "" in the criteria row for a field in the query design grid,
then see if any records are returned when you run the query. I think this
is what Allen meant.
 
A

Allen Browne

My 3rd reply in this thread explained what criteria to use to check for
zero-length strings.
 
G

Guest

At this point, I want to say thanks to Allen and all the MVPs and others who
have assisted me in this matter. I have learned a lot and appreciate all
your time and efforts. It is time now to close this thread. Your help has
been wonderful.
 

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

Error Message for Append Query 10
Table Fields and Properties 1
How do I avoid key violations in append queries 7
Access 2002 Append Query Problems 1
Append query not working due to Validation Rule Violations 14
Unable to append due to key violations 1
Append query wont run because: 8
Type conversion failure on Append 12

Top