creating a report with Access

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

i have a table called '2005' that shows all incoming payments for the past 3
years. what i need to do is make it show me a report that shows the following:
payments by vendor for each year and have the total at the bottom of the
report.
Vendor is Field 7 Payments is Field 15 Payment date is Field 4

Thank you for the help
 
i have a table called '2005' that shows all incoming payments for the past 3
years.
Click to expand...

Well, I'd call the table Payments; storing data such as a year in a table name
- ESPECIALLY wrong data, since table 2005 evidently contains data from 2006,
2007 and 2008 - is bad design.
what i need to do is make it show me a report that shows the following:
payments by vendor for each year and have the total at the bottom of the
report.
Vendor is Field 7 Payments is Field 15 Payment date is Field 4
Click to expand...

Create a Query based on the table. Include the vendor and payments fields
(usually fields have names, not numbers); add a calculated field by typing

PaymentYear: Year([payment date])

in a vacant field cell, using your actual fieldname of course.

Make the query a Totals query by clicking the Greek Sigma icon (looks like a
sideways M). Leave the default Group By in the Totals row on the vendor and
PaymentYear fields, and change it to Sum on the payment field.

You can make the report Footer visible in report design and put a textbox in
it to sum the subtotals in the SumOfPayments field; make its control source
something like

=Sum([SumOfPayments])
 
Back
Top