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

record yes/no data as 1/0 in datasheet

P: 1
Hello,

I'm working on an access database and I have a lot of yes/no checkboxes. I would like these variables to store in my corresponding datasheet as 1/0 variables, as I'm planning on exporting the datasheet for analysis in SAS.

How would I get these variables to display as checkboxes on the form, but as 1/0 variables in the datasheet? I'm a fairly beginning Access user...

Thanks!
Heidi
May 13 '10 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,616
@hsoeters
Let's suppose that you have a Yes/No Field in your Table named Check1. Create a Query based on this Table with a Calculated Field we'll call [Status] that will display True (Checked) Values as 1 and False (non Checked) Values as 0. You would then Export the Query.
Expand|Select|Wrap|Line Numbers
  1. Status: IIf([Check1],1,0)
May 13 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.