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

Query a checkbox in Access

P: 1
I'm not sure if this is the right forum for posting this but I will take my chances. I have a table with checkboxes in one of my columns with some checked and others not. I want to query just my checkboxes. How do I do this?
May 18 '07 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
I am moving this post to the Access forum.

ADMIN
May 18 '07 #2

puppydogbuddy
Expert 100+
P: 1,923
Assuming you have the checkbox bound to a boolean field in your table, you can query the checkboxes that have been checked as follows:

SELECT [YourCheckboxField]
From [YourTable]
WHERE [YourTable].[YourCheckboxField] = True

Just replace "True" with "False" in the above select statement to query the unchecked checkboxes.
May 18 '07 #3

Post your reply

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