Yes/No Field Using Make-Table Query

[LoopyNZ]

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!