Page subtotal in MS Access 2003 Report
-
I have a MS Access 2003 report that simply displays data from columns in one Access table. One of the columns is called Amount. The Report Footer displays the Total on a text box calculated as Sum(Amount) and works fine. I want to display the Amount subtotal for each page but when I assign Sum(Amount) to a textbox in the Page Footer I get an error at runtime. How can I display the subtotal of Amount column on each page?? (I cannot group as the records have nothing in common) :rose::rose: 1fm1fu
-
I have a MS Access 2003 report that simply displays data from columns in one Access table. One of the columns is called Amount. The Report Footer displays the Total on a text box calculated as Sum(Amount) and works fine. I want to display the Amount subtotal for each page but when I assign Sum(Amount) to a textbox in the Page Footer I get an error at runtime. How can I display the subtotal of Amount column on each page?? (I cannot group as the records have nothing in common) :rose::rose: 1fm1fu
And this has what to do with VB/VB.Net? So far, you haven't mentioned any code problems you might be having. Just something with the Report Designer in Access. You might want to try finding an Access Forum for this question. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome