sum function error

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hi sorry if this is a repost. My last effort seems to not show in the list so
here goes again.
I have a main form and it contains a subform
on the subforms footer it has a sum function to calculate the total.
=Sum([SPQty]*[SPUnitPrice])
somtimes this produces an error and goes on endlessly calculating for some
reason I cannot figure out. Mostly it works fine but once the error happens I
have to close the program to make it work again.
if I use the subform on its own and not within the main form the sum works
fine every time.
any help most apreciated as its so strange.
IM using Vista and access 2003
Steve - from a land down under
 
Steve said:
Hi sorry if this is a repost. My last effort seems to not show in the list so
here goes again.
I have a main form and it contains a subform
on the subforms footer it has a sum function to calculate the total.
=Sum([SPQty]*[SPUnitPrice])
somtimes this produces an error and goes on endlessly calculating for some
reason
Click to expand...

Your earlier post showed up fine here and I responded there.
If you still have trouble finding it, try searching Google
Groups for the thread.
 
dans l'article (e-mail address removed), Steve à
(e-mail address removed) a écrit le 23/01/08 3:25 :
 
Back
Top