SUM function in ACCESS FORM

  • Thread starter Thread starter philip
  • Start date Start date
When I try to sum figures in page and group footers, I get
an error message . Any ideas?
Click to expand...

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!
 
philip said:
When I try to sum figures in page and group footers, I get
an error message . Any ideas?
Click to expand...

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
 
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
 
Back
Top