Access - Printing

Resolved · Low Priority · Version 2003

Access - Printing

Susan has attended:
Access Introduction course

by - delegate Susan [3 posts] (2008 Aug 20 Wed, 16:51) Reply

How can I print records in a series (not consecutive)

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 - Printing records which are not together!!

by - trainer Rajeev gold contributer [462 posts] (2008 Aug 21 Thu, 17:06) Reply

Dear Susan

Thank you for attending Access Introduction course. I hope you enjoyed the course and benefited from it.

If I understand correctly you would like to print records that will be meeting a certain criteria. It is best to create a query.

You can print records that are together but cannot print records that are not together.

If tehere is a specific situation that you'd like to point out to me that you want to print records that are not together then please let me know by giving an example and I'll try to see if we can find a way around this obtacle of printing.

Please mark this post as resolved if it has answered your question otherwise simply press the reply button for further explanation!!

Mnay thanks

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007

· Microsoft Access, an Efficient Database Tool
· How Reorganising Your Data Can Take Your Business to the Next Level
· Microsoft Access 2007: New Features
· Access Database Optimization: First Normal Form
· Want to Become the Office Hero? MS Project Training Could be the Answer

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