Reports

Resolved · Low Priority · Version Standard

Reports

Matthew has attended:
Access Introduction course
Access Intermediate course

by - delegate Matthew [2 posts] (2008 Mar 18 Tue, 16:40) Reply

Can you create and save templates for quickly creating future reports?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 25 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Nov 26 Wed	Tooting	0	FULL
2003	2008 Dec 2 Tue	Southwark	5	book now	£198	£215
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
Full Schedule: See all 55 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Reports

by - trainer Pete platinum contributer [799 posts] (2008 Mar 25 Tue, 10:02) Reply

Hi Matthew, Thank you for the post, in answer to your question; because the report is dependant upon an underlying query or table, you are restricted in how much you can pre-create, but there is no reason why you should not create a template (blank report) with the appropriate formatting and design (labels) in particular areas which you can then populate with fields when you need to use it. In order to point your 'template' at the right table or query you will need to change its Source in the report properties though. I hope that helps, best regards Pete.

· Why Do I Need To Use Access?
· How to Find a Third-Party Venue for Microsoft Access Training
· Access VBA Handling Errors and Debugging Code
· Microsoft Access as a Business's Database Management System
· Microsoft Access, an Efficient Database Tool

Please browse our web site to find out more about
microsoft+access+course 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