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 » Union Queries

	98.1 % recommend us
	More live stats...

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

Training information:

Union Queries

Resolved · Urgent Priority · Version 2003

Reply Thu 20 Aug 2009, 14:00Delegate Vishal said...

Vishal has attended:
Access Introduction course
Access Intermediate course
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Access Advanced course

Union Queries

Hi, I would like to merge two columns in two seperate tables which are linked together by a common ID ref number. The columns have the same title.

Can you please explain how to do this.

There is a query already set up in Access which does this for other fields, but this has been created using SQL adn I do not understand it. If I click on the design view to review the query, all I get is SQL code.

For upcoming training course dates see: Pricing & availability

Reply Thu 20 Aug 2009, 15:56Trainer Stephen said...

RE: Union Queries

Hi Vishal

Thank you for your question

Union queries can only be written in SQL as Access's query builder will not create Union Queries. All I can suggest is changing the field names in the existing query so that they reflect the data you want to merge.
Alternatively, if you like, you could copy the SQL into a post along with and example of the names of the new fields and tables and I can rewrite the SQL for you

Regards

Stephen

Access articles

· How To Show JPG Or GIF Images In Access 2003 Forms
· It Is Important To Take Care Over Primary Key Assignment
· User-Proofing Your Access Database: Part 1
· A Brief Guide To Table Relationships In Access
· Manage Your Macros With Access 2010

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

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips