Countif

[Sgt Bilkp]

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

 

[KenHigg]

Perhaps a dcount() would work here - ?

 

[CEH]

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.

 

[missinglinq]

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

 

[Sgt Bilkp]

Managed to suss it using a DCount function.