richardparker
New member
- Local time
- Today, 22:55
- Joined
- Dec 9, 2015
- Messages
- 8
Hi Guys,
I have encountered the following problem and despite my efforts to find the solution through the o mighty google, I couldn't come up with anything useful so far:
I've set up my table where I register manually issued invoice receipts. Invoice total -wise, the table only stores the Net invoice amount and since the VAT rate is fixed I calculate the VAT and the Gross invoice amount on the queries/reports etc.
There is also a True/False field to indicate whether the invoice was settled or not.
Since these invoices are paid via bank-transfer I created a continous form for the daily registration of the incoming payments of the invoices.
It is basically a list with all the unsettled invoices.
To facilitate the matching of the invoices with the payments there is a calculated field on the form for every record with the gross value as the incoming amounts appearing on the bank account are the Gross invoice values.
Out of mere curiosity I wanted to sum up the calculated gross values in the form footer in a field using the expression builder of the Control Source. However the only result got was #Error.
I am a "a simple man, and of delicate constitution" so what tried so far was:
=Sum([Gross_invoice_amount])
after reading somewhere that it is not possible to Sum calculated values on a form I tried the followwing:
=Sum([Net_invoice_amount]+Round([Net_invoice_amount]*0,27;0))
I have encountered the following problem and despite my efforts to find the solution through the o mighty google, I couldn't come up with anything useful so far:
I've set up my table where I register manually issued invoice receipts. Invoice total -wise, the table only stores the Net invoice amount and since the VAT rate is fixed I calculate the VAT and the Gross invoice amount on the queries/reports etc.
There is also a True/False field to indicate whether the invoice was settled or not.
Since these invoices are paid via bank-transfer I created a continous form for the daily registration of the incoming payments of the invoices.
It is basically a list with all the unsettled invoices.
To facilitate the matching of the invoices with the payments there is a calculated field on the form for every record with the gross value as the incoming amounts appearing on the bank account are the Gross invoice values.
Out of mere curiosity I wanted to sum up the calculated gross values in the form footer in a field using the expression builder of the Control Source. However the only result got was #Error.
I am a "a simple man, and of delicate constitution" so what tried so far was:
=Sum([Gross_invoice_amount])
after reading somewhere that it is not possible to Sum calculated values on a form I tried the followwing:
=Sum([Net_invoice_amount]+Round([Net_invoice_amount]*0,27;0))