Multiple Expressions in Form Footer

[Hank Stalica]

I have a form with a text field sums totals from the details section of
the form (=Sum([EbayFees])) which works fine.

When I attempt to add a second text field to sum another value
(=Sum([WinningBid])), both fields get #Error.

Why is this and what am I doing wrong?

Thanks,

--Hank

 

[Tom Wickerath]

Hi Hank,

Access can sometimes get confused when textboxes are named the same as the fields. So, for
example, if you have a textbox named WinningBid, and you have a field by the same name, it may
not know what to do with it. Suggest that you use some type of naming convention, if you are not
already doing so. Here are a couple of links regarding naming conventions:

Commonly used naming conventions
http://www.mvps.org/access/general/gen0012.htm
http://www.xoc.net/standards/default.asp

Special characters that you must avoid when you work with Access databases
http://support.microsoft.com/?id=826763

Reserved Words in Microsoft Access
http://support.microsoft.com/?id=286335


Tom
_______________________________________


I have a form with a text field sums totals from the details section of
the form (=Sum([EbayFees])) which works fine.

When I attempt to add a second text field to sum another value
(=Sum([WinningBid])), both fields get #Error.

Why is this and what am I doing wrong?

Thanks,

--Hank