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 » Access 2003

	98.1 % recommend us
	More live stats...

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

Training information:

Access 2003

Resolved · Medium Priority · Version 2003

Reply Tue 3 Aug 2010, 14:27Delegate Jo said...

Jo has attended:
Excel Intermediate course
Excel Advanced course
Access Introduction course

Access 2003

1. If I set up a query which I use to base another query on and I change the fields in the query what affect will it have on the any other queries?

2. How do you merge two queries

For upcoming training course dates see: Pricing & availability

Reply Mon 9 Aug 2010, 14:03Trainer Simon said...

RE: Access 2003

Hi Jo,

Thank you for your question.

As a query is based on fields from a table, any changes to the underlying data in the table will be updated in the query results.

If a query is based on a query and you change the criteria of the original query and the query based on it should update too.

Please find the following link attached to explain the joining of two queries by creating a Union Query:

http://www.ehow.com/how_6535557_write-union-query-access-2003.html

I hope this answers your question.

Regards

Simon

Access articles

· Microsoft Access Training Unleashes the Power of the Pivot Table
· A Quick Intro On How Access Uses SQL
· How Reorganising Your Data Can Take Your Business to the Next Level
· Practice Microsoft Access Database Decorum To Reap The Rewards
· How To Understand Access As A Relational Database

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

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