Countif

Sgt Bilkp

Registered User.
Local time
Today, 13:33
Joined
Jan 11, 2008
Messages
66
I seem to be having some trouble with my Option Group boxes

I have three options, returning a 1/2/3 value depending on setting.

Within the main form, i want to be able to have a footer showing the overall number of records resulting in the corresponding value (1/2/3)

The Option group is called servicability (sic)

I have tried a hidden text box in the form returning the value and countif-ing that, still get the #Error message
 
Perhaps a dcount() would work here - ?
 
I've used something like this on reports to summarize...... For example an option group for "Gender"... Male or Female. In my query of the form I would add a new field..... Male: IIf([Gender]=1,1,0) and one more Female: IIf([Gender]=2,1,0)
Then on my report I simply sum the fields for my count...... Textbox on report like "TotalMale" with control source as..... =Sum([Male])

You might be able to adapt that for your form.
 
I suspect the answers given will surfice, but no one mentioned that Countif() is an Excel function not an Access function. You actually can use Excel functions in Access, I believe, by setting the proper reference, but you shouldn't need to here.

Linq
 

Users who are viewing this thread

Back
Top Bottom