LarryDeLaruelle
Technical User
I set up a make table query to extract a subset of my records to append to another table. Many of the fields are Yes/No check boxex.
In the newly created table they display as 0's and -1's instead of check boxes.
When I try to append those records to another table, I get a Key Violation error. I removed the key field (an autonumber) but that did not help.
I tried the append directly (without an intervening make table) and got the same error.
When I did a make table of both data sets, with the result that in both new tables the check boxes became 0's and -1's, the append works.
Is there a problem in appending data in 0 and -1 format with data in check box format? If so, how can I force Access to use check boxes instead of 0 and -1 when I do the append/make table.?
Thanks.
Larry De Laruelle
larry1de@yahoo.com
In the newly created table they display as 0's and -1's instead of check boxes.
When I try to append those records to another table, I get a Key Violation error. I removed the key field (an autonumber) but that did not help.
I tried the append directly (without an intervening make table) and got the same error.
When I did a make table of both data sets, with the result that in both new tables the check boxes became 0's and -1's, the append works.
Is there a problem in appending data in 0 and -1 format with data in check box format? If so, how can I force Access to use check boxes instead of 0 and -1 when I do the append/make table.?
Thanks.
Larry De Laruelle
larry1de@yahoo.com