How count horizontally on a report if textboxes have any value
Please see attachment. This is a rough draft of a report I'm trying to design.
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
=IIF(isnull(Field1),0,1)+I