hylander wrote:
My apologies for what to many of you will probably seem a simple
problem. I have a number of queries which result in numerical answers.
Is it possible to have access total these for a report. The database I
am running uses Windows XP and NT - Office 2000 and 2003. The server it
uses cannot have links with other Office applications. Thanks in
anticipation.
I'll assume you have the query already in place.
You might want to start by creating a report based on the query. Do
this by using the ReportWizard (Reports/New/ReportWizard).
Do you want to display the detail and totals displayed for each numeric
column? As you step thru the wizard you will see where you can group
the report and later where you can sort the report. Group on a field.
On the sort page, at least in my version, is a SummaryOption button.
Click that to sum, average, get the min/max values of the column.
There's an option to specify if you want to present both detail &
summary data or just summary data.
You might want to play around with it. Once the report is created, you
can also check the Sorting&Groupings option under the View option in the
menu bar. You might want to read up on RunningSums in Help also. Try
to create a couple of running sums simply to get some experience.