By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,222 Members | 1,133 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,222 IT Pros & Developers. It's quick & easy.

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

P: n/a


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
Dec 4 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <Sv********@Versatel.nlwrote in message
news:47**********************@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
Dec 5 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.