Improve company productivity with a Business Account.Sign Up

x
?
Solved

Access Union Queries in Design View

Posted on 2009-05-08
3
Medium Priority
?
241 Views
Last Modified: 2012-05-06
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
Comment
Question by:tahirih
  • 2
3 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft Access MVP) earned 2000 total points
ID: 24339329
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
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft Access MVP)
DatabaseMX (Joe Anderson - Microsoft Access MVP) earned 2000 total points
ID: 24339340
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
 

Author Closing Comment

by:tahirih
ID: 31579600
Thanks.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question