Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » MS Access

	98.1 % recommend us
	More live stats...

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

Training information:

MS Access

Resolved · Low Priority · Version 2003

Reply Thu 19 Feb 2009, 16:34Delegate Kathryn said...

Kathryn has attended:
Access Introduction course
Access Intermediate course
Excel Intermediate course

MS Access

I am unable to think of a question at this moment but I am sure I will think of one related to this course when I get back to my office and start using Access. Could I still have access to the on-line support. Many thanks

For upcoming training course dates see: Pricing & availability

Reply Sun 22 Feb 2009, 23:55Trainer Rajeev said...

RE: MS Access

Dear Kathryn

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

Of course you can have the full access to the on-line forum support. The first question is to trigger the 12 month support that you have achieved by your query!!

We at Best (STL) look forward to answering your questions in the future!!

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

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

Mon 2 Mar 2009: Automatically marked as resolved.

Access articles

· Understanding The Components Of Access
· How Access Can Provide The Key To Successful Stock Management
· Tips for designing databases in Microsoft Access
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· A Quick Intro On How Access Uses SQL

Please browse our web site to find out more about
access courses in london and other Microsoft training courses.

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