Hi,
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

Matt,

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

=[NumberOfDays]*[RatePerDay]

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

=Sum([NumberOfDays]*[RatePerDay])

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.

MVPS Access FAQ
Reports: Print only the current record to a report
http://www.mvps.org/access/reports/rpt0002.htm

- 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

OK.

- Hammer

---

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

Matt,

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

thanks, another great answer