Calculated Fields

K

Kelly

Hi. I was wondering if anyone could help me with a
difficulty Im experiencing in Access. Im trying to
calculate a total figure in a form. I have the two
figures I wish to add together, but when I enter the
formula =[Price for adults]+[Price for Children] and look
at the form in Form view, the field just has #Name? in
it. Ive been trying to sort this for hours now, and any
help would be greatly appreciated!
thanx!
 
R

Roger Carlson

What is the name of the textbox? The textbox cannot be named the same as
either of the fields it is referencing. Try naming the textbox something
like txtTotalPrice.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculation Based on Dynamic Variables (What-if Scenario) 0
Error when calculating form fields 2
requerying a main form calculated fields from after subform data entry 7
Total Detail on Continuous Form 5
calculated field in a form 1
Sum Calculated Field Question 1
save calculate value 2
How do I get the combo box to link with costs field in the table? 1

Top