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

  • Thread starter Thread starter deaconj999
  • Start date Start date
D

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
 
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'")
 
Back
Top