Records Created Sum per Day

  • Thread starter Thread starter mrs.brucewayne
  • Start date Start date
M

mrs.brucewayne

I want to make a query (or something) that totals all the records that were
created that day but I don't know how. I have a sick log and a query that
pulls the records each day but I need to know how many people called in sick
each day and have it sum it in a report with just the total number not the
records.

Thanks.
 
Create a new query in design view. Add the table. Add the date field and
your selection criterion.

Click the Totals button (looks like a sideways "M").

Add the table's primary key field. Use "Count" on this field. Use "Group
By" on the date field.

You should get the count of records, grouped by date.

(of course, if your date field has date AND time, you'll need to calculate
the DatePart() of the value before Group By)

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top