Reports

Resolved · Low Priority · Version 2003

Reports

Vaz has attended:
Access Introduction course
Access Intermediate course

by - delegate Vaz [2 posts] (2008 Aug 14 Thu, 16:58) Reply

If there are more fields than can fit on one page will the report be spread over two pages and if so will it re-print the key field on each page? (similar to excel and setting the columns to repeat on each page)

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 26 Wed	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 28 Fri	Bloomsbury	3	book now	£240	£245
2003	2008 Dec 3 Wed	Southwark	7	book now	£203	£230
2003	2008 Dec 19 Fri	Bloomsbury	6	book now	£214	£230
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
Full Schedule: See all 47 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Reports

by - trainer Pete platinum contributer [799 posts] (2008 Aug 20 Wed, 09:20) Edited on 2008 Aug 20 Wed, 09:21 Reply

Hi Vaz
Thank you for the post and welcome to the forum, the answer is No; there is no way for it to automatically appear on each page. However there is a workround for this problem which is quite straighforward;
You will just need to place the Field/s into the Page header in order for this to happen.
I hope that has helped, regards Pete

· Three Myths About Microsoft Access
· How to Find a Third-Party Venue for Microsoft Access Training
· Microsoft Access Mistakes to Avoid
· Microsoft Access Beginners' Training: Getting to Grips with Databases
· Microsoft Access 2007: New Features

Please browse our web site to find out more about
microsoft access training and other Microsoft training courses.

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options
Ø No

§ This Item is not a running total

Ø Over Group

§ This Item is a running total which will reset to zero with each new group value

Ø Over All

§ This Item is a running total which will total over the whole report