Pulling subtotals or grand totals into reports?

[baxton]

Hi Everyone hope you can help, i am designing a "simple":-) estimating tool for my business, not used access for a while but understand some formulas etc.


I am having an issue pulling the Grand totals into reports

I have a main sheet tbl and qry - which holds all my Labour costs for the job.
I also have a materials table which i have set a qry and is a subform on my main sheet.
which has item | price|qty|total etc.

so all the formulas work great!. whoop!

so issue is that any formula i have to calculate the "column totals" ie
Material1 price qty subtotal (total price*qty)
Material2 price qty subtotal
Material3 price qty subtotal
on the form footer i have to get the grand total from the subtotal with
grand total price*qty which works ok, but it doesn't get stored anywhere!? or I don't know how to store it? more likely

so on my Report
I want to be able to just show

client details
the labour grand total
material grand total
and over all total?

i hope this makes sense and thanks for your time
all the best
baxton

[Micron]

If the presentation is good, you are done. Not only do reports not feed back edits into tables/queries, you shouldn't store totals anyway in 99.987% of cases.
This might help with the concept (or confuse)...
http://allenbrowne.com/AppInventory.html

[Gicu]

I think the OP wants to show the grand total from the form (used for data entry) onto a printable report. To do that you would either need to recalculate it on the report itself (just like you do on the form), get it from a totals query (where you group by your unique ID coming from the form and total the prices), use a dSum to do the same or probably the easiest (if the form is open when you open the report) by referencing the control you already have in the form's footer (enter =Forms!frmYourForm!txtGrandTotal in the control source of a textbox on the report used to display the grand total).

Cheers,

[baxton]

Hi Guys, thanks for your help ill give it another go with the new insights,
so if am correct in thinking that I should build a report query based on
client
labour
materials
create the report based on the qry
then treat the report more like a form than a "stored" and get totals from formula from the report data?

cheers again thanks for your support
Baxton