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.
 
Back
Top