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.
 
F

faxylady

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
Unable to append due to key violations 2
Access 2002 Append Query Problems 2
How do I avoid key violations in append queries 7
Append query wont run because: 8
Type conversion failure on Append 12
Running into error while writing Append Query 3
VBA code to loop append query fails 3

Top