• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 238
  • Last Modified:

Access Union Queries in Design View

Please offer how I may create a Union Query in Query Design View - not with SQL. I can do this via an Append Query, but would also like to know of a JOIN method of accomplishing this.

The only Join options are Inner or Outer

Thanks
0
tahirih
Asked:
tahirih
  • 2
2 Solutions
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
You can't in Access.  You must use the SQL view. However, you can use the designer to create the SQL for each part of the UNION ... then copy and paste those into NotePad ... and then into a new blank UNION in SQL view.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
And in general I use this (for editing queries, etc)

http://www.4tops.com/query_tree.htm

It has a Find and Replace that is very cool.

mx
0
 
tahirihAuthor Commented:
Thanks.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now