sum in continuos form

[knaya]

i have a continuos subform and i have a textbox on the main form that calculates the sum of all values from the sale textbox.. my code is:
=Sum([sale])
buy immediatly i view it the value shows #error.. how can i solve this..thanks

 

[KenReay]

Hi

Could be several things, but one to check - what is teh name of the text box with the =Sum([Sale]) as the source?, ensure it is NOT Sale

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[knaya]

Ken,that textbox is called text25...any more ideas on what can be wrong?? Thanks

 

[ZmrAbdulla]

Hi,
Check this

thread702-708776

Zameer Abdulla

http://www.mtkhoory.com

http://www.aikah.com

 

[knaya]

ZmrAbdulla,
i saw it but couldnt figure it out:-(, can u further break it down on what exactly i'm suppose to do?? Thank you

 

[ZmrAbdulla]

If you are using Access2000 please download this sample from microsoft. It will explain how to do it

http://support.microsoft.com/?kbid=233324

Regards

Zameer Abdulla

http://www.mtkhoory.com

http://www.aikah.com