How to use and Inner Join in the Access Query Designer

[ba1959nh]

I am helping someone with an Access 2003 db.


She is trying to set up a query using the Access Query Wizard/Designer.
The query requires an INNER JOIN between tables.
I cannot figure out where to put the INNER JOIN parameter in the query designer which is used to design and execute queries INSIDE the Access User Environment (as opposed to VBA code or external db).

I am really hoping that someone can help with this.
She does not understand straight SQL queries and relies on Access's Query Builder/Wizard/Designer to set up her queries.
I figure if I can set up a few examples, it will be very helpful.
When I refer to the Access Query Builder/Wizard/Designer, I mean the screen in Access that shows the following components of a query:
Field:
Table:
Sort:
Show:
Criteria:
or:

I just need to know where/how to include an INNER JOIN clause.

Here is the SQL Query:

SELECT TransactionID, EventID
FROM TransactionHistory
INNER JOIN Events
ON TransactionHistory.EventID = Events.EventID


So I guess I am trying to map the SQL statement above to the Query Builder UI (screen fragment shown below):
Field: EventID
Table: Events
Sort:
Show: [X]
Criteria:
or:[/b]


I appreciate any help that can be provided.
Thanks,
Bill

[ba1959nh]

The Access Query Designer will create the joins
when adding the tables in the Show Tables dialog
(as long as the DB Relationships have been configured).

Use View -> SQL View to see the Designer generated SQL command.

Add Criteria in the Designer to complete the Query.