SUM function in ACCESS FORM

[philip]

When I try to sum figures in page and group footers, I get
an error message . Any ideas?

 

[Jay Bukstein]

Whats the message?

 

[John Vinson]

When I try to sum figures in page and group footers, I get
an error message . Any ideas?

Yes; I'd suggest that you post some more information, such as the name
of the field that you're summing, the Control Source of the textbox
which should contain the sum, and the error message.

YOU can see your screen. We cannot. Give us a little help here!

 

[Emilia Maxim]

When I try to sum figures in page and group footers, I get
an error message . Any ideas?

philip,

what error message? How are you trying to sum (VBA code, function in
control source, other, please post exact code/function)? What Access
version?

Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de

 

[Michel Walsh]

Hi,


A page, of paper, is not a known element in SQL, it is NOT a "group"
break recognizable through a change of data. You have to make the summation
yourself. The general way is to initialize a report variable to 0 at the top
print event, make the cumul at the appropriate detail print event, then, at
the footer print event, display it inside a text control or a label caption
you would have designed at that effect.

Now, if you plan to do it for a FORM, that is even worse, since it
clearly depends of the size (user re-sizable? ) form, or the number of
records actually displayed.



Hoping it may help,
Vanderghast, Access MVP