Query which copy table

[Ardoos]

Hi!
I have problem with query which is used to create copy of table. I create query with all fields of table "Players" and select Create table. Query work and create table "Copy_Players", but one of fields is field Yes/No. In original table "Players" I have check box which is selected or no. In copy created by query i have only values -1 for checked and 0 for unchecked. How to create query which makes check box? Or how to change this values in check box?

[June7]

This is a Format property setting. Why bother with in table? Set property of bound control on form or report.

Why do you have a procedure that routinely makes table? This is usually a bad design because it modifies database structure. Better to create table once and then delete records. This is a 'temp' table - the table is permanent but the records are temporary.