473,397 Members | 2,068 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 software developers and data experts.

record yes/no data as 1/0 in datasheet

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
1 1335
ADezii
8,834 Expert 8TB
@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

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

Similar topics

5
by: deko | last post by:
I have a subform datasheet that contains a full year of records sorted by a date field. I'm trying to programmatically move the record selector on the datasheet to the first record that matches a...
1
by: Oliver Gabriel | last post by:
Hello, i have a form with a tab control in it. the tab control has 3 pages. all three pages contain forms as children, and they all use the same table. For example, if a user now enters data in...
1
by: Trevor Fairchild | last post by:
Hello all - I've been working in VB6 for about a year and now I've moved "up" to VB.NET. I think I would have fewer problems in learning vb.net if I knew nothing about previous versions of vb......
1
by: wesley.d.gibbs | last post by:
I have a MS Access 2000 problem. My access database has quite a few tables (about 10) but my problem is only w/1 table and this 1 table has a 1 to 1 relationship w/1 other table. Every once...
4
by: LFM | last post by:
I have a form that includes a subform for data entry. The subform is setup to view only one record at a time. I need to limit that subform to only allow the user to enter one record at a time,...
8
by: holy moly | last post by:
Hello, I am trying to make a PHP/HTML update script for MySQL. I prompt the user to enter the ID# of the record they wish to update into a form which then uses the passed ID# to select...
1
by: StinkyDuck | last post by:
Is there a record type in vb.net which is similar to the record data type in delphi? -StinkyDuck
3
by: pzh20 | last post by:
I have an unbound form/subform where I populate a combo box on the main form, and using the onchange event, display fields from a table in a datasheet subform. I want to add a new record via the...
1
by: menkenk | last post by:
Good Afternoon, I currently have an issue in trying to get a macro working for clicking a record in a subform datasheet to open a form with the complete record details of that specific record....
1
Jerry Maiapu
by: Jerry Maiapu | last post by:
Hi Please help. How can I delete i single record in a datsheet subform from main form using a delete button on the parent form.? i will be more grateful for your help... jm
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.