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