Append queries

[kom73]

I posted this question a week ago and no-one was able to help... maybe someone out there can now.......

I am protecting my data by using a draft table and a replica archive table. Records are archived using an append query to transfer the data from 'draft' to 'archive' followed by a delete query to clear the 'draft' table.
Both queries have criteria to select the current record on my draft form. The form has a button that runs both queries (append, delete)using a macro.
My problem is that when I run the query I get an error message (no detail given). All of the data is appended correctly except the YES/NO fields. I have set the fields to yes/ no in both tables (data type and format) and in the properties of both queries........

....so what going wrong? pleeeease can anyone help - its driving me mad + deadline looming...

thank you

 

[Rich_Lovina]

Sometimes its your field lengths which may be set incorrectly . I have solved an append which would not append all data by taking a dummy append, fields one by one until I get the error. Then this determines the field causing the error and where properties may differ.

Hope this helps. Good Luck