Quick Links ▼

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » access 2003 training course london - To reply from Forum.

	98.1 % recommend us
	More live stats...

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

Training information:

access 2003 training course london - To reply from Forum.

Resolved · Low Priority · Version Standard

Reply Thu 26 Jul 2007, 11:06Delegate Jeannie said...

Jeannie has attended:
Access Intermediate course
Access Advanced course

To reply from Forum.

Could I see the questions you replied to other Forum uses? If I dould them how do I open to view their replied from you. Thank you.
Regards
Jeannie

For upcoming training course dates see: Pricing & availability

Reply Thu 26 Jul 2007, 12:10Trainer Amanda said...

RE: to reply from Forum.

Hi Jeannie

Thank you for your question.

If you go into the forum you wish to view posts and responses from, then click on any of the posts shown, you will be able to see a trainer's response to any questions that have been answered.

Amanda

Access articles

· How To Understand Access As A Relational Database
· Access Corruption Avoidance Tip #2: Avoid Dangerous Data
· Some Simple Database Questions Answered
· Reasons to Consider Microsoft Access Training
· Microsoft Access 2007: New Features

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