append query returns 0 results

Question

Hi,

I have created an append query using design view of query design and when I run it, no results come through. I am trying to put any record that has the value of "true" in a yes/no box into another table. I have tried enabling zero values for all the data types that are text or memo, as there are many fields in the main table that lack values, but nothing has worked yet.

I do however, have a update query to reset all the values of the checked boxes to "false" on the main table once I get them copied to this second table, and that works without flaw.

Looking for some help here.

Thanks

Answer 1

thanks for the heads up about SQL view.

I didn't change the query, i wanted it to append records that had a value of true in a yes/no field, and there were values of true in the yes no field. i didn't change anything other than just redoing it a couple times...

Answer 2

When in Query Design mode change the View to SQL View. This will show the SQL for the query. You can then copy and paste that into a response here.

If the SELECT statement showed nothing then your criteria is too restrictive. You probably chjanged some criteria to make it work

Answer 3

i have no clue how i would show the sql code. I also did as you have said, running it as a regular select query before making it append query. That didn't help, though somehow I got it to work when i was recreating the query.

thanks

Answer 4

Can you post the SQL of your statement so we can possible see what's wrong.

Also, before converting a query to an Append query, I run it as a SELECT query to see if it returns the correct records