Access

Resolved · Low Priority · Version Standard

Access

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

by - delegate Shelley [4 posts] (2008 Feb 20 Wed, 16:17) Reply

Is there anyway, on the reports to get the header on more than one page, if the report is over multiple pages?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	2	book now	£215	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
2003	2009 Jan 6 Tue	Southwark	5	book now	£198	£215
Full Schedule: See all 51 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Access

by - trainer Pete platinum contributer [816 posts] (2008 Feb 23 Sat, 09:46) Reply

Hi Shelley, Thank you for your post, In answer, in reports we have Report headers and Page headers, the report header will only appear on the first page of your report, however the Page header will as it says appear on every page. Try incorporating your required page header in the space provided. I hope that helps, best regards Pete.

· How to Find a Third-Party Venue for Microsoft Access Training
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· Convert a Paper Trail to a DBMS
· Microsoft Access Training Unleashes the Power of the Pivot Table
· Take an Access Course to Learn About Relational Databases

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

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips

Rate this page: