#name? error on report totals.

[Maclain]

Hi Everyone!

I have a report that builds a customer invoice.

There is a sub total, VAT and Grand total figure.

The sub total called txt100 does =Sum([Job Price])

the VAT figure, called txt101 does =(([txt100]/100)*17.5)

the grand total, called txt102 does =([txt100]+[txt101])

Which works fine, until I close and re open access, then txt101 and txt102 return a #NAME? error.

Any ideas why? and If there is a better way of returning the correct figures.

Ta!

 

[Mr Smin]

Not sure why this fails only after restarting access.

You could, experimentally, try
txt101=(Sum([JobPrice]))*0.175

which avoids referencing txt boxes by name.

 

[Maclain]

That works.

Strange though!

VAT now reads =(Sum([Job Price]))*0.175

and Grand Total reads =((Sum([Job Price]))*0.175)+(Sum([Job Price]))

And after closing and re opening access, it still works.

Lovely!

 

[Mr Smin]

You could simplify grand total to
=((Sum([Job Price]))*1.175)
note the new multiplier

makes it easier on the eye and might save access a bit of work (i'm not sure how it handles Sum operations behind the scenes but it might be doing all the summing work each time you specify it)