Groups with Subtotals and GrandTotal

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have what I think is a simple report. It is an access report with the
following fields:

WRF Number
Date Received
Date Completed
Turn_Around (Formula field: diff between Date Completed and Recieved)

I need to be able to group by month and do subtotals on the Turn_Around
field, with a grand total at the end on the Turn_Around field.

Can someone help me. Can't get the 'Sorting and Grouping' thingy to work.

phmckeever
 
You need to decide which date you want to group by: either Received or
Completed. If you select a date field in your sorting and grouping dialog,
you will have the opportunity to select Month as the Group On value.
 
Choose to display the Group Level Footer (or Header) in the sorting and
grouping dialog. You can then use a text box in one of these sections with a
control source like:
=Sum(DateDiff("d",[Date Received], [Date Completed]))
 
Back
Top