sum function error

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
 
M

Marshall Barton

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 :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum function on subform error 6
if a # then sum, if text leave null 2
DLookup in Continuous form 0
display sum from subform to mainform 7
ApplyFilter gives error only when subform is placed on main form 1
Not understanding the hasdata function 3
referring to Subform Total in main form 1
Sum Function Error 1

Top