Help using conditional count in form header

F

Floyd Forbes

Is it possible to have a textbox in the form header to count
the number of a conditional textbox in detail section? I get #Error.

Thanks
 
G

Guest

What did you try that you get an error?

Try:
=Sum(IIf(YourConditionIsTrue,1,0))

So, the IIf will return 1 if the condition s met, and the Sum will add up
all the 1'ns
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum If function in textbox 0
Running Total from a Subform 1
dcount 1
Listbox selected count 3
Problem setting filter with code - is it a bug? 2
Conditional Formatting question 4
SetFocus is ignored 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Top