Help using conditional count in form header

  • Thread starter Thread starter Floyd Forbes
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

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
Problem setting filter with code - is it a bug? 2
Listbox selected count 3
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
Conditional Formatting question 4
SetFocus is ignored 4

Back
Top