sums of dates

  • Thread starter Thread starter Kay
  • Start date Start date
K

Kay

currently, i have a database that holds data taken on
certain dates. Let's say i have 15 referrals on 9/16/03,
that means there are 15 different records for 9/16/03. On
a report, i want to report that on 9/16/03, there were 15
referrals so that it looks something like this:

9/12/03 12
9/15/03 10
9/16/03 15

where there were 12 referrals on the 12th, 10 refs on the
15th, and 15 refs on the 16th. How do i make a report
that will give me those totals?
 
Try a Query with the SQL String something like:

SELECT ReferralDate, Count([ReferralID])
FROM tblReferral
GROUP BY ReferralDate

which should give you the date and the number of Referrals
on that date. You can use this Query as the RecordSource
for your Report.

HTH
Van T. Dinh
MVP (Access)
 
Hi

Use the grouping option in the report. If you are using
the Report Wizard, double-click the field you want to
group by in the Grouping Window, e.g. Date or if you are
creating the report in Design view, click the Grouping and
Sorting icon, select the Date field and change the Group
Footer to Yes.

In report design, create the following calculation in the
Date Footer
=Count([Date])

This should count the number of referrals for each day.

Hope this helps.


Regards


MG
 
Back
Top