expression builder help

  • Thread starter Thread starter Pritesh_karma
  • Start date Start date
P

Pritesh_karma

in a report ive designed, im trying to use the expression builder.
im hoping that what i can do is select a record. get a total count, a
count where it equals 1, a count where it equals 2.
for the total count, i use ==Count(PROCUREMENT!INSTITUTION_ID) as my
control source.
Im sure theres a way to get a count for records equal to 1 and records
equal to 2.

What would i have to put in the control source.
=(Count(PROCUREMENT![2A]=2)) i tried this, dosnt seem to work.
 

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

Excel VBA - counting cells by colors and names to it in two different rows. 0
Excel Need Countifs Formula Help 0
Cross checking a total from the parent table to the child table? 6
Counting number of records based on criteria 2
Access Dcount (multiple criteria) 3
Counting on a report 2
Count sfrm records 2
multiple counts, same calculated field, different parameters 6

Back
Top