access course microsoft training

access course microsoft training - Need Help

Resolved · Low Priority · Version Standard

Need Help

Jonathan has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

by - delegate Jonathan [4 posts] (2007 Aug 22 Wed, 13:48) Reply

Hi everyone

Im trying to produce a report and for some reason the total amount that i have created wont work on footer page. I also made an experiment... and i moved that total amount on the Header area and it works!... do you know why it produces an error on the footer area?

thanks

Jonathan

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	3	book now	£475	£495
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Need Help

by - trainer Rich platinum contributer [744 posts] (2007 Oct 4 Thu, 14:01) Reply

Hi Jonathan,

Sorry for the delay in getting back to you.

First of all, are you sure it's a Report Footer and not a Page Footer? Page Header/Footers do not really work within sub reports, but Report Header/Footers should.

So check that first.

The other thing could be that you mistyped the function (eg. SUM) or used the incorrect syntax. eg. try adding the exact same thing (copy/paste) from the header that works to your footer, and run report with both.

There are also Page Margins and Footers to consider.

Let me know how you go.

Regards, Rich