
December 17th, 2003, 03:22 PM
|
|
Registered User
|
|
Join Date: Dec 2003
Posts: 3
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Help with Totals
This seems as easy thing, but I just can't get it to work.
In a report, I have a textbox named Miles, which is bound to Miles in a table. I added another textbox with "=sum([Miles])" this is how I thought it was done and I checked the help and this is how it is meant to be done.
When I view the report, however, the text box shows #error instead of the total of the Miles. I have checked to make sure the relevant text box is called Miles and it is, I cannot see why this is happening. Thank you
EDIT: This is Access XP
~Ewan
PS - In case you were wondering, it's called Miles because of the measurement of distance, not the name :).
Last edited by Ewan : December 17th, 2003 at 03:25 PM.
|