Solved

How count horizontally on a report if textboxes have any value

Posted on 2014-10-16
2
149 Views
Last Modified: 2014-10-16
Please see attachment.  This is a rough draft of a report I'm trying to design.

Rough draft
The challenge is to count the number of textboxes that have any value in them.  So in this case the ??? answer would be 4.  Each textbox obviously has a unique name and uses a unique table field as it's control source.

How can I do this?

--Steve
0
Comment
Question by:SteveL13
2 Comments
 
LVL 39

Expert Comment

by:als315
ID: 40385247
May be better to write function, but you can use:
=IIF(isnull(Field1),0,1)+IIF(isnull(Field2),0,1) ...
0
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 40385397
Or without all the IIfs:

=Len(Field1 & Field2 & Field3 & Field4 & Field5 & Field6 & Field7 & Field8)

/gustav
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

757 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now