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

How to perform a count of a Y/N field

P: 1
Good Day
I am trying to create some charts/graphs from a ms access 2007 database containing y/n answers but I am not getting the correct results by pulling data from the queries. I used the query wizard to create the query and it displayed all of the raw data, however when drawing the graph for the y/n records, Access created a chart with all of the values equal to the total number of y/n records in the query. Is it possible for someone to sum a series of "yes" without the use of SQL/VBA language?
Apr 30 '15 #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,397
Short answer - no.
You have to have the SQL/VBA to count the records.
Please take a moment to open your query in design mode.
Then right click in the table area of the GUI
Select "SQL View" from the shortcut menu
Copy the string you find there into a post within this thread
Select that string and then format it using the [CODE/] format control.

In the meantime you might find this article helpful
•Why I stopped using Yes/No fields
Apr 30 '15 #2

Post your reply

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