I would like to count the number of fields on a report based on a criteria. I can count the number of fields by using =Count([Text1]) on a fields record source. But how can I say Count only the fields whose value is N? I know this can be done on a query but can it done on a report? Thanks...
Counts on a report
- Thread starter gbanks
- Start date
- Local time
- Today, 16:11
- Joined
- Feb 28, 2001
- Messages
- 30,393
Well, .....
yes and no.
The easiest way to do this is to write a query that includes the answer to your question by counting the records where N = whatever value was important to you.
You could, however, load a report's text-box with a DCount function that counts what you want if you give it the correct criteria.
yes and no.
The easiest way to do this is to write a query that includes the answer to your question by counting the records where N = whatever value was important to you.
You could, however, load a report's text-box with a DCount function that counts what you want if you give it the correct criteria.
- Local time
- Today, 17:11
- Joined
- Feb 19, 2002
- Messages
- 47,415
You can also use an IIf(). But in that case you would use Sum() rather than Count().
=Sum(IIf([Text1] = "N",1,0))
=Sum(IIf([Text1] = "N",1,0))
