Advertisement

11.02.2007 at 05:04AM PDT, ID: 22934528
[x]
Attachment Details

Access Union Tutorial Query

Asked by squidlings in Microsoft Access Database, SQL Query Syntax, Access Architecture/Design

Tags: union, query, access

Hi,

I would really appreciate it if somebody could run me through how to use Union Queries.
I'm totally new to union queries and don't have a clue where to start.

I would love it somebody could run me through a very basic example to I can see the theory of how they work?

i.e.

TBL1_ACC

ACC NAME
ACC NUM

TBL2_ACC

ACC NAME
ACC NUM

In is example, I have tbl1 and tbl2, say I've had a new computer system installed and as a result all the account numbers have changed. I'd like to update Acc Num from TBL1 with the ACC NUM from TBL2.

Is this easy to do?  I'm pretty good with, select, append, update and make table queries, but there isn't a union query so I didn't even know they existed until the other day :) Please help me.
Start Free Trial
 
Keywords: Access Union Tutorial Query
Title
1 UNION
2 Error: Incorrect syntax near the keyw…
3 Union and order
4 UNION in query
5 Union Query Syntax
6 Problem with UNION query
 
Loading Advertisement...
 
[+][-]11.02.2007 at 05:12AM PDT, ID: 20199977

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.02.2007 at 05:21AM PDT, ID: 20200050

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.02.2007 at 05:31AM PDT, ID: 20200115

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]11.02.2007 at 05:34AM PDT, ID: 20200136

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]11.02.2007 at 05:58AM PDT, ID: 20200366

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.02.2007 at 06:20AM PDT, ID: 20200529

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.02.2007 at 07:14AM PDT, ID: 20201021

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.02.2007 at 07:16AM PDT, ID: 20201040

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.02.2007 at 07:20AM PDT, ID: 20201060

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.02.2007 at 07:21AM PDT, ID: 20201063

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Access Database, SQL Query Syntax, Access Architecture/Design
Tags: union, query, access
Sign Up Now!
Solution Provided By: capricorn1
Participating Experts: 3
Solution Grade: A
 
 
[+][-]11.02.2007 at 07:29AM PDT, ID: 20201148

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628