Formula in Form Footer Field Control Source

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a continuous subform. Each record has a dropdown with a value
selected. I would like to put a field in the form footer that counts the
number of records being displayed with a specific value in the dropdown.

What formula can I use?
 
Bill said:
I have a continuous subform. Each record has a dropdown with a value
selected. I would like to put a field in the form footer that counts
the number of records being displayed with a specific value in the
dropdown.

What formula can I use?
Click to expand...

=Sum(IIf([SomeField]="SomeValue",1,0))
 
Thanks for your help with this Rick!

I was trying to do something similar with the DCount formula but this is
much easier! Sometimes you can over complicate things!

Thanks again!
Todd

Rick Brandt said:
Bill said:
I have a continuous subform. Each record has a dropdown with a value
selected. I would like to put a field in the form footer that counts
the number of records being displayed with a specific value in the
dropdown.

What formula can I use?
Click to expand...

=Sum(IIf([SomeField]="SomeValue",1,0))
Click to expand...
 
Back
Top