Union Query (1 Viewer)

amunafc

Registered User.
Local time
Today, 20:23
Joined
Dec 17, 2009
Messages
62
Please help me with this union query from the tables provided.


Amunafc:D:D
 

Attachments

  • Union Query.zip
    33.7 KB · Views: 87
Last edited:

amunafc

Registered User.
Local time
Today, 20:23
Joined
Dec 17, 2009
Messages
62
JoanneJames

Yes I want to come up with one query when I combine the common field in both tables.
 

amunafc

Registered User.
Local time
Today, 20:23
Joined
Dec 17, 2009
Messages
62
what union query? All you have are two tables...

I want a union query from the two tables and after that I want to run 'Make Table Query' so that the data from both tables should appear in one table
 

JoanneJames

Registered User.
Local time
Today, 13:23
Joined
Feb 19, 2008
Messages
59
Have you tried looking up Union queries in help? There should be plenty of examples out there...
 

amunafc

Registered User.
Local time
Today, 20:23
Joined
Dec 17, 2009
Messages
62
Have you tried looking up Union queries in help? There should be plenty of examples out there...
I have managed the query 'Union' but it's got some bug. Please could help to remove the bug? Try to run the query and see where the bug comes from:D:D
 

Attachments

  • Union Query.zip
    39.1 KB · Views: 89

d_profesor

Registered User.
Local time
Tomorrow, 00:23
Joined
Jan 17, 2008
Messages
43
I have managed the query 'Union' but it's got some bug. Please could help to remove the bug? Try to run the query and see where the bug comes from:D:D

You don't have [Y-1_Approved] field in the qMT_Project_E. ;)
 

Users who are viewing this thread

Top Bottom