Urgent Help please Count or SUM ???????

[deaconj999]

I need to know how to count the values in a column witihn a query.

I mean I have a column risk factor and 3 values in my table of H M L,
I would like to produce a query that counts all the H and allows me to
put that query dtright on to a table for emailing.

I have reached a point where my report already produced has the normal
=Count(*) embedded as a sub report for this value but it disappears
whn an email attachment is created.

I would now rather produce the email report with no sub reports or sub
forms on the report, just the report based on the query.

Of course once I have the formula I can use it to count other values
in other columns and add them to the report, but ALAS I cannot find
the correct formula syntax.

I am desperate as it forms part of a FIre Safety Database for a very
large fire department in th UK.

Many thanks in anticipation

Joe

 

[Guest]

If you want to count something that is not the part of the report's record
source, you can use a subreport or DCount() or DSum() or other.

For instance to count RiskFactor values of H, you might use:
=DCount("*","[Your Table]","[RiskFactor]='H'")