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 » Relationships

	98.1 % recommend us
	More live stats...

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

Training information:

Relationships

Resolved · Low Priority · Version 2007

Reply Tue 24 Mar 2009, 17:23Delegate Helena said...

Helena has attended:
Access Intermediate course
Access Advanced course
Access VBA course

Relationships

Could you please tell me what an inner join is?

For upcoming training course dates see: Pricing & availability

Reply Mon 30 Mar 2009, 11:33Trainer Carlos said...

RE: Relationships

Hi Helena

The definition of an Inner Join is:

A join that selects only those records from both database tables that have matching values.

Records with values in the joined field that do not appear in both of the database tables will be excluded from the query. One or more fields can serve as the join fields.

For example an Inner join on the Customers and Order tables will only show Customers with Orders and leave out any customers without Orders or Orders without Customers.

The inner join is also known as an equi-join.

The inner join is the default join type in Microsoft Access.

Hope this helps

Carlos

Thu 9 Apr 2009: Automatically marked as resolved.

Access articles

· One To Many Relationships In Access
· When Is Microsoft Access Not The Best Choice For Your Business?
· Microsoft Access 2007: New Features
· How To Create Navigation Forms In Microsoft Access
· So what's new in Access 2007?

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