Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft/access/training/courses - Outputting Reports

microsoft/access/training/courses - Outputting Reports

ResolvedVersion Standard

Wed 28 Nov 2007, 16:49 Delegate James said...

James has attended:
Access VBA course
Access Advanced course

Outputting Reports

Is it possible to output a report to a program that creates Read-only documents, such as CutePDF Writer.?

Mon 10 Dec 2007, 11:01 Trainer Richard said...

RE: Outputting Reports

Hi James

Thank you for your question regarding Access Reporting.
A very simple way of doing this is using a 3rd party PDF printer driver, that allows to PRINT to a PDF file.

There are several free versions, and I personally use something called PDF995. If you search on google for that, it normalls requires you to install two files, and then you can use it.

Access iteslf does not have a PDF printer available in the program. Once you install the PDF printer, you can use it for all windows programs

Regards

Richard
Microsoft Office Specialist

Mon 10 Dec 2007, 11:07 Delegate James said...

RE: Outputting Reports. PDF creation.

Richard.

I am aware that Access doesn't have its own PDF printer, I just didn't know if the report needed to be saved as a separate file first.

Thanks for your help

James

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Calculating The Difference Between Dates

If you wish to calculate the time between two date fields, this can be done in a number of ways:

1. As a calculated field in a query
2. As a calculated control in a form or report
3. As a calculation in a VBA procedure.

The basic syntax to get the number of days between two dates is:

=[One Date Field] - [Another Date Field]

You can also use one of the following functions:

=Month([One Date Field] - [Another Date Field])
which calculates the number of months between the two fields

=Year([One Date Field] - [Another Date Field])
which calculates the number of years between the two fields.

Another function is the DateDiff() function.

It uses an argument to determine how the time interval is measured. For example:

=DateDiff("q",[One Date Field] - [Another Date Field])
returns the number of quarters between the two fields.

Other intervals that can be used in this expression are as follows:
"yyyy" - Years
"m" - Months
"d" - Days
"w" - Weekdays
"ww" - Weeks
"h" - Hours
"n" - Minutes
"s" - Seconds

View all Access hints and tips