Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count with criteria 1

Status
Not open for further replies.
srogers

srogers

Technical User
Aug 15, 2000
201
US
I have a report grouped by Equipment Type and it is based on a query involving 3 tables.

I want to count Field A if it equals 15.
Field A is a text field and I don't want to group by it.

Is there a formula I can put in the report footer that will work?

I tried =Count[FieldA]='15'
But it counts all the records.

Thank you.
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

ptrifile
  • Locked
  • Question
Sum with multiple criteria
Replies
2
Views
317
dhookom
dhookom
RonMcIntire
  • Locked
  • Question
Page Numbering a report with vba
Replies
6
Views
405
dhookom
dhookom
Kennelbloke
  • Locked
  • Question
Problems with image on report 1
Replies
8
Views
288
dhookom
dhookom
breezett93
  • Locked
  • Question
What should be multiple reports is becoming one report with multiple pages 1
Replies
13
Views
385
dhookom
dhookom
nikademous
  • Locked
  • Question
Line Method for use with expanding controls
Replies
3
Views
283
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top