Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Count Questions in Access 2010 Table

Posted on 2015-02-09
1
113 Views
Last Modified: 2015-02-09
I have an access table that I need to count the non-null values in each row. In the attached spreadsheet notice the count in the Total_Questions Column. I'm trying to figure out how to calculate either in a query or using VBA, Thanks
Count.xlsx
0
Comment
Question by:shieldsco
1 Comment
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 40599706
you can use a query like this

select
Iif([q1] & ""<>"",1,0)  +
Iif([q2] & ""<>"",1,0)  +
Iif([q3] & ""<>"",1,0)  +
Iif([q4] & ""<>"",1,0)  +
Iif([q5] & ""<>"",1,0)  +
Iif([q6] & ""<>"",1,0)  +
Iif([q7] & ""<>"",1,0)  As Total_questions
From TableName
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question