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

Yes/No Field Using Make-Table Query

P: n/a
Hi all,

(Access 97)

I'm trying to use a number of make-table queries to create some Yes/No
fields, but I'm not having much luck. Has anyone found a trick to get a
make-table query to make a Yes/No field rather than an Integer (or Text)
field?

My field is a calculation that returns an integer, and wrapping CBool
around it and formatting it as True/False haven't worked.

Thanks,
-------
LoopyNZ
-------

PS I know I could use work-arounds (e.g. make the table then append
results to it), but I'm wondering if there's a way to do it without
going outside the make-table query.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.