Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft+access+course - query

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft+access+course - Query

microsoft+access+course - Query

ResolvedVersion Standard

Christian has attended:
Access Introduction course

Query

How do I run a query linking data from different tables?

RE: Query

Hi Christian

I trust that you found you Access Introduction cousre helpful.

To link different tables together within a query, you will need to start a query, add the tables that you want and then create a link between them. To do this you will need to drag the primary key from one table to the foriegn key in the other table, this will then set up the link.

Hope this helps
David

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.



Access provides an easy method of achieving a running total.



Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.