There is an option to create a report using the wizard. You could try that,
but from what I have seen it does a lot of unnecessary stuff.
In the database window (the window that appears when you first open a
database), click the Reports tab. Select "Create report by using wizard" if
you want to give that a try. Otherwise click "Create report in Design
view". It may be worthwhile using the wizard just to see how the various
formulas and so forth are used to determine the totals.
I can't walk you through the entire process from scratch, but here is a
summary if you are using desgn view. When you create a report in design
view you will see a blank report and a property sheet with tabs for Format,
Date, etc. Click the Data tab and select your table. A field list will
appear. Drag the Qty and Rate fields from the field list onto the Detail
section. Click View >> Toolbox if you do not already see the toolbox.
Click the Text Box icon, and draw a text box on the report. Click the text
box to select it, then click View >> Properties (or use the Properties icon
on the toolbar). On the Data tab, enter the following as the Control
Source:
=[Qty] * [Rate]
Click View on the menu bar, and select Report Header and Footer. Draw
another text box in the report footer (be sure it is the report footer, not
the page footer), and add the following Control Source:
=Sum([Qty] * [Rate])
Click View >> Sorting and Grouping. Select the field(s) on which you wish
to sort the data.
For more description it may be worthwhile to go to:
http://allenbrowne.com/casu-22.html
Also, there is lots of information here:
http://allenbrowne.com/tips.html
and links to many more sources of information here:
http://allenbrowne.com/links.html