98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » access course microsoft training - Need Help
access course microsoft training - Need Help
Resolved · Low Priority · Version Standard
Wed 22 Aug 2007, 13:48Delegate Jonathan said...
Jonathan has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Need Help
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
Thu 4 Oct 2007, 14:01Trainer Rich said...
RE: Need Help
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:DsumYou can create percentage values based on individual products / items by using a Dsum function (used with a grouped query) |
