Report Summaries

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

Guest

In my report, I currently have a summary that calculates and displays a daily
average (located in my "date" field footer) and then an overall weekly
average (in my report footer) at the end of the report (the report is ran
once weekly). I did this report through the wizard, but now need to add new
summaries to calculate averages for yet another field. How do I do this
without totally going through the wizard again? Where is the option in the
design view? Also, the averages I must now calculate are in a time format of
hh/mm/ss.00 (hours, minutes, seconds and hundredths). How do I go about
doing this?
 
In my report, I currently have a summary that calculates and displays a daily
average (located in my "date" field footer) and then an overall weekly
average (in my report footer) at the end of the report (the report is ran
once weekly). I did this report through the wizard, but now need to add new
summaries to calculate averages for yet another field. How do I do this
without totally going through the wizard again? Where is the option in the
design view? Also, the averages I must now calculate are in a time format of
hh/mm/ss.00 (hours, minutes, seconds and hundredths). How do I go about
doing this?
Click to expand...

A Report is based (usually) on a Query. You can change that Query;
open the report in design view, find its Recordsource property
(View... Properties), and click the ... icon by it. Add or change any
fields you like. They'll now be available in the field list in Report
design and you can drag them onto the report. Or, you can create
textboxes on the report - say on a footer - and set the textbox's
Control Source to an expression such as

=Avg([fieldname])

Access Date/Time fields have a resolution accurate to the nearest
second. Actually, they're stored accurate to a few microseconds - but
Access provides no way of dealing with fractional seconds. In
addition, date/times are not really suitable for storing durations;
they're best reserved for storing precise instants of date and time.
If you want to store durations, I'd suggest using a Double Float
number count of seconds and fractions of a second; use an expression
like

[Dur] \ 3600 & Format([Dur] \ 60 MOD 60, ":00") & Format([Dur] -
60*([Dur] \ 60), ":00")

John W. Vinson[MVP]
 
Back
Top