Change Given

[guytheripper]

I need to make a field in a form for a change given.
I have a grand total also a amount tendered, All i need now is a change given.
The problem is that i have the expression =([TENDERED]-[GRAND TOTAL])
Insted of the change i get the error message '#Name?'.
Can anybody help me with this problem???

Also i need the grand total to show up in the table, at the moment i only have it visible in the form.

All help is appreciated.

 

[ghubbell]

One of the field names you're using in your expression isn't being recognized. Try clearing the control source for your control with the problem, and using the expression builder ("..." button just to the right of the control source), click through the builder to create the expression you require.

There is no advantage to storing the results of a calculation (your grand total) in a table. If you can see it on a form because it is derived from a calculation, you can always extract the same information by a similar calculation anywhere in the database...! Gord
ghubbell@total.net