Adding counts?

[bill1856]

I have a report which shows employee hiring status. In the header I have a =Count(*) textbox to count the total number of applicants. The body of the report (run from a query) is two textboxes: =Count([Status]) and a box to show the status.
I have about 20 status categories. Half of them are hirable, half are not. What I'm looking to do is have two counts in the header which show hirable and unhirable totals.
I'm looking for something like this:

Count "Accepted Position" + "In Training" + "Offer"...
Count "Declined Position" + "No Offer"...

Any suggestions?

 

[dhookom]

Do you have any table structure (query fields) that you could share with us? Do you have a lookup table for [Status] values? If so, you could add a field to the lookup table that designates hirable. I would use an integer field and use 0 for unhireable and 1 for hireable.

You could then add the [Hireable] field to the report's record source and sum it.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]