Rather simple I know but......

I have a table with a Yes No field formatted for a tick / no tick
I run a make table query - including the Yes No field and the new table 
has the format minus 1 
No problem to me - but a user may be flummoxed
I can overcome the problem by changing the field to number format and back 
to Yes No and the table now shows ticks / no ticks

Can someone tell me how to keep tick / no tick when I Query make table?

Simon

Simon,

<< I have a table with a Yes No field formatted for a tick / no tick
I run a make table query - including the Yes No field and the new table 
has the format minus 1
 
No problem to me - but a user may be flummoxed

I can overcome the problem by changing the field to number format and back 
to Yes No and the table now shows ticks / no ticks

Can someone tell me how to keep tick / no tick when I Query make table? >>

Here's one way.

1) Run your make-table query the first time and do what you need to do to 
get the tick marks to come back.

2) Delete the data in the new table but keep the table itself.

3) Change your make-table query to an append query.  Make it append to 
your empty table.

4) Run your future queries from this saved append table.

Since your table is already set up, the tick marks will stay tick marks 
when data is added.  The only drawback is that you must clear the target 
table of data before you run your new append query each time.

Greg