Query

The UK's most regular instructor-led training courses.
Training information: training for microsoft access · Access training · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2007

1 post

ReplyMon 22 Jun 2009, 14:14Delegate Susan said...

Susan has attended:
Access Introduction course

Query

How do you create a calculated field?

Version	Date	Location	Places available	Book	Next place rate (£)
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Wed 24 Mar 2010	Bloomsbury	5		£240	£245
2003	Tue 6 Apr 2010	Southwark	9		£203	£208
2007	Thu 13 May 2010	Bloomsbury	7		£188	£193
2003	Tue 18 May 2010	Bloomsbury	9		£182	£187
2003	Fri 2 Jul 2010	Bloomsbury	7		£85	£90
2003	Thu 19 Aug 2010	Southwark	10		£75	£80
Full Schedule: See all 10 Access Advanced course dates. Bookings currently available until 14th December 2010.

870 posts

ReplyTue 23 Jun 2009, 12:55Trainer Rajeev said...

RE: Query

Dear Susan

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

I have answered a similar type of query in one of my posts.

Please refer the following link that explains how the calculated fields are created in Access Query:

http://www.microsofttraining.net/post-20536-access-database.html

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
MCT

· It's so easy to Access the information you need
· Microsoft Access: Unleash the True Potential Today
· Microsoft Access Training Unleashes the Power of the Pivot Table
· What You Need To Know About New Security Features In Access 2007
· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course

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

All prices offered for business users and exclude VAT. E&OE · Terms and Conditions

Query

Query

RE: Query

Related articles

Access tip:

Calculating The Difference Between Dates