Using caluculated controls across forms. and Reports.

[Hrtlover]

Hey all.

I have a form with 3 subforms on it.


It is a invoicing form. and i have it set up as 3 tables for the form. one for the invoice id number and customer details of the invoice,
One for the services or 'lines' of the invoice (in which you can enter rates on the form)
and one to calculate the grand total after payments (so a form to add a payment, which takes it away from the grand total)

a couple of questions though.

To work out the Grand total, i have 3 calculated controls on the one form

• TotalexclGST (Unit price*units)
• GST (TotalexclGst *0.1)
• Grandtotal (Totalexclgst+gst)

How do i write the Grand Total to the table? and
How do i use it in another another calculated control on a different (main or sub) form and record that one as well?

Also, when createing a report based on this, and using the ID number as the query parameter, it doesn't seem to want to bring up any information. Although this may be user error..

Unfortunately, i cannot upload the database due to it being a Certificate III in IT assignment mixed with a proper database that i will be using for our company. But it needs to be my work ...


Any help would be muchly appreciated.

Thanks!

[pkstormy]

You may have to put some of the calculation within the query itself. That way, when you sum it on the report/form, it sees it as an actual field versus a field with an expression. This then allows you to do additional calculations against the summed field since you can only sum off of a summed (calculated) field so many times.

Be careful though, sometimes adding in calculations into the query will make that query non-editable.