yes/no

[Guest]

Hi
I have a table with 2 fields
1) Product (text) 2) Is_Big (yes/no
when I export the table to text I am getting 1 instead of yes and 0 instead of no

What querry do I need in order to transform back the 0 into no and the 1 into yes

Many thanks
k

 

[[MVP] S.Clark]

Select Product, Format(0, "Yes/No") from Products

Even though Access calls it a Yes/No field, it's really stored as -1 and 0.
So, the Format function will get you there.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-