Google Answers Logo
View Question
Q: ms access report ( Answered 5 out of 5 stars,   0 Comments )
Subject: ms access report
Category: Computers > Programming
Asked by: mattie54-ga
List Price: $2.00
Posted: 16 Apr 2003 04:08 PDT
Expires: 16 May 2003 04:08 PDT
Question ID: 191114
I wish to make a report in access which is a customer invoice. I
basically have what I want as a form but wish to make it as a report.
My first problem is how do I store fields from the table which are
calulated and just have a data source which is a sum into the table so
they can be displayed in the report or alternatively how do I perform
sums in a report.

Also with my report I am unable to make it display just 1 customer's
details which is what I want! I need to know how to just display one
record so I can effectively make an invoice.

Thanks, matt
Subject: Re: ms access report
Answered By: hammer-ga on 16 Apr 2003 05:02 PDT
Rated:5 out of 5 stars

You don't normally store the results of a calculation in your table.
You recalculate on forms and reports as needed. For example, say you
store the NumberOfDays and the RatePerDay in your table and you want
your report to show the TotalBillingForBooking in each row, you create
a text box on your report and you set the ControlSource to


If you also want to total the TotalBillingForBooking at the bottom of
the column, create a text box in the Group Footer and set the
ControlSource to


There are all sorts of calculations and summaries that you can do in a
report. In the Access Help Answer Wizard, search for

report sum

There should be a topic titled "Calculate a total or other aggregate
values". Take a look at it. Read the examples.

For your second question, the DoCmd.OpenReport call takes an argument
that can be used to filter the report records. There is a topic on the
MVPS Access FAQ that discusses this. You can also read the Help for
OpenReport. Look at the part about the Where Condition.

Reports: Print only the current record to a report

- Hammer

Request for Answer Clarification by mattie54-ga on 16 Apr 2003 14:36 PDT
thank you! looks like tht works. Will give it a good test and then
come back with any problems or rate you

thanks again, matt

Clarification of Answer by hammer-ga on 16 Apr 2003 14:54 PDT

- Hammer

Clarification of Answer by hammer-ga on 18 Apr 2003 11:15 PDT

I see that you expired your other question. Are we done with this question?

- Hammer

Request for Answer Clarification by mattie54-ga on 19 Apr 2003 05:33 PDT
Hi, yep I managed to sort the otherone myself. sorry about that.

Done with this one- Thanks for your help, matt

Clarification of Answer by hammer-ga on 19 Apr 2003 06:10 PDT
Great! Good luck with the rest of your project!

- Hammer
mattie54-ga rated this answer:5 out of 5 stars
thanks, another great answer

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy