Groups with Subtotals and GrandTotal

[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

 

[Duane Hookom]

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.

 

[Guest]

How do I get the totals for the groups; and, then the grandtotal?

phmckeever

 

[Duane Hookom]

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]))