how to calculate the number of record monthly

  • Thread starter Thread starter jims
  • Start date Start date
J

jims

I am trying to print a report with a summary for each and
try to calculate the number of field for each.
I use the Dcount function in the [Date by month] footer
sth like below:
DCount("[no]","qry Inspection Record Monthly","[dg onboard]
='Yes'") but my problem is that the I don't know how to
specify the DCount for each month because the qry will
return all the record in a year. So, how can I use the
function to calcalate the number of records per month in
the report.
PLease help!??
 
If you have a footer for a group of records that you want to query, then you
should not be using DCount(). For instance you could use:
=Abs( Sum([dg onboard] = "Yes") )
This assumes [dg onboard] is a text field. If it is a Yes/No field:
=Abs( Sum([dg onboard] = -1) )
 
Back
Top