Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training - Access

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

microsoft access training - Access

Resolved · Low Priority · Version Standard

Reply Thu 14 Jun 2007, 16:27Delegate Bill said...

Bill has attended:
Access Introduction course

Access

How do you alter preset formats for reports in Access ?

For upcoming training course dates see: Pricing & availability

Reply Mon 18 Jun 2007, 11:07Trainer Richard said...

RE: Access

Simply run the wizard to get the basic outline, and then go to design view. All aspects of the report are changeable. You do need a bit of expereince and knowledge about how to change the details.

You will cover the basics on the course today, and our intermediate course gets info much more detail.

Access articles

· How To Import Data Easily Into Access 2010
· What You Need To Know About New Security Features In Access 2007
· The Benefits of Certified Microsoft Training in Access
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· Want To Find Out About Access Queries?

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