Text box sums

[MeredithPfeiffer]

I have a text box that should be the total sum for three fields -
Storage Expense $150
+ Towing Expense $100
+ Other Charges $100

but the sum keeps coming up as #Name? instead of $350.

Anyone know how to fix this?

 

[Remou]

What line are you using to sum?

 

[MeredithPfeiffer]

I'm not sure if I know what you mean?

 

[Remou]

What line have you typed in the textbox that shows the error #Name?

 

[MeredithPfeiffer]

I have it under control source as:
=[storage expense]+[towing expense]+[other charges]

I have several other text box sums and they are all coming out this way. I have done them before and they worked so I know I am missing something.

 

[Remou]

Are you very sure that these are the names of the controls? I have found that I can sometimes miss a slight difference in a name.

 

[PHV]

Are [storage expense], [towing expense] and [other charges] all field names in the form's underlaying query/table ?


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PHV]

BTW, you may give the expression builder a try.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886