Difficulty in Make-Table query, TickBox transfer in to binary value

Dear reader,



In a Make-Table query the TickBox from the master table transfers in to a
binary value in the new table.

How can I force the Make-table query to keep the TickBox in the new table as
it is in the master table a CheckBox.



Thanks for any help.

Kind regards,

Simon

Re: Difficulty in Make-Table query, TickBox transfer in to binary value

The simplest solution is to create the table the way you want it, and then
use an Append query to populate it. If desired, you can copy'n'paste the
table in the Database Window (or Nav Pane in A2007.)

If that's not satisfactory, please give more detail. What you you mean by a
"binary" value:
a) Do you mean you get a Yes/No type field, with the values 0 or -1 for
No/Yes?

b) Or are you saying Access creates a field of type Binary? That should only
occur if JET is unable to determine the correct data type for the field
(typically where it's a calculated field.) If this is the case, you may be
able to typecast the calculated field with CBool() to get the desired
result.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Simon" wrote in message
news:4755d01b$0$4792$bf4948fe@news.tele2.nl...
>
> Dear reader,
>
> In a Make-Table query the TickBox from the master table transfers in to a
> binary value in the new table.
>
> How can I force the Make-table query to keep the TickBox in the new table
> as
> it is in the master table a CheckBox.
>
>
>
> Thanks for any help.
>
> Kind regards,
>
> Simon