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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
My 3rd reply in this thread explained what criteria to use to check for
zero-length strings.
 
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
Appending table autonumber problem 5
How do I avoid key violations in append queries 7
Append Query - Key violation 1
Access 2002 Append Query Problems 1
Appending Records and Key Violations 3
Table Fields and Properties 1
Modifying table design breaks Append query 2

Back
Top