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...
 

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

Select Specific Fields of Query Based On Variable Field 0
subform total behaving strangely 2
Reference to calc field on sister subform? 1
Continuous form on continuous form 2
Using a Combo Box for Filtering a Continous Form 1
SubForm Footer wont reload fast enough 4
calculated control event order 2
Need combo box to refresh when moving to new record 2017 1

Back
Top