When I use Yes/No field in access, the data gets exported as True/False in Excel.
Is there a way where I could assign 0/1 for a Yes/No field?
When I use Yes/No field in access, the data gets exported as True/False in Excel.
Is there a way where I could assign 0/1 for a Yes/No field?
yes, but just use -1 (which = true)
thats what checkbox are for,
thats what yes/no will also do.
thats what TRUE/FALSE will also do.
if you dont like the negative displayed, show in query as Abs([field]).
Thanks for the reply.
I was referring to the Yes/No data type in tables. I was hoping for a way to store the data directly as a number without the use of a query or form.
From your answer, I understand that it is perhaps not possible, and the data can be stored only as Yes/No, True/False, or On/Off in the table.
Boolean (yes/no) fields are stored as -1 / 0 but displayed using one of the format methods you listed.
Similarly date time field are stored as numbers but displayed in whatever format you choose
Thanks for the explanation. I was not aware of that.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.