please help with report

  • Thread starter parisa.naghshpour
  • Start date
P

parisa.naghshpour

i have an access project to finish by tomorrow....and i am STUCK!

Please help:

i have 4 tables and i need to create a report that shows data from
each table and calculates a running tab of charges / subtotal / tax /
total for each customer


i have the relationships created and the data is all entered i just
cannot figure out how to do the expressions...

thank you.
 
N

niuginikiwi

If I understand correctly,
You have a few more steps to nail this.
First you have to create some queries that will calculate your totals.
Then use the query as the source of a report and in the report have a
CustomerName group with header and footer enabled.
Put the details ( you can have a subform here) in the CustomerName group
header and put your totals on the footer of the customerName group and on
their running sum property to whole group
This is just an overall explanation to give you some direction.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Weekly Report 2
Consolidation Table from Different Excel Tabs with Different Format 1
Creating a Chart on form from selected data in query. 0
Help creating a search form in Access XP 0
How to implement two shifts per day with multiple teams 0
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
multiple conditions 8

Top