A amunafc Registered User. Local time Today, 21:36 Joined Dec 17, 2009 Messages 62 Feb 16, 2011 #1 Please help me with this union query from the tables provided. Amunafc Attachments Union Query.zip Union Query.zip 33.7 KB · Views: 111 Last edited: Feb 16, 2011
J JoanneJames Registered User. Local time Today, 14:36 Joined Feb 19, 2008 Messages 59 Feb 16, 2011 #2 what union query? All you have are two tables...
A amunafc Registered User. Local time Today, 21:36 Joined Dec 17, 2009 Messages 62 Feb 16, 2011 #3 JoanneJames Yes I want to come up with one query when I combine the common field in both tables.
A amunafc Registered User. Local time Today, 21:36 Joined Dec 17, 2009 Messages 62 Feb 16, 2011 #4 JoanneJames said: what union query? All you have are two tables... Click to expand... 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 said: what union query? All you have are two tables... Click to expand... 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
J JoanneJames Registered User. Local time Today, 14:36 Joined Feb 19, 2008 Messages 59 Feb 16, 2011 #5 Have you tried looking up Union queries in help? There should be plenty of examples out there...
A amunafc Registered User. Local time Today, 21:36 Joined Dec 17, 2009 Messages 62 Feb 17, 2011 #6 JoanneJames said: Have you tried looking up Union queries in help? There should be plenty of examples out there... Click to expand... 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 Attachments Union Query.zip Union Query.zip 39.1 KB · Views: 112
JoanneJames said: Have you tried looking up Union queries in help? There should be plenty of examples out there... Click to expand... 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_profesor Registered User. Local time Tomorrow, 01:36 Joined Jan 17, 2008 Messages 43 Feb 17, 2011 #7 amunafc said: 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 Click to expand... You don't have [Y-1_Approved] field in the qMT_Project_E.
amunafc said: 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 Click to expand... You don't have [Y-1_Approved] field in the qMT_Project_E.
A amunafc Registered User. Local time Today, 21:36 Joined Dec 17, 2009 Messages 62 Feb 17, 2011 #8 d_profesor said: You don't have [Y-1_Approved] field in the qMT_Project_E. Click to expand... Thank you so much. I was about to drop it out. Thank once again 1000x
d_profesor said: You don't have [Y-1_Approved] field in the qMT_Project_E. Click to expand... Thank you so much. I was about to drop it out. Thank once again 1000x