Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

union queries

ResolvedVersion 2003

Edward has attended:
Access VBA course
Access Intermediate course

Union Queries

Is there any way to creat Union queries without using SQL?

RE: Union Queries

Dear Edward

Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.

The short and sweet answer to your question is unfortunately you cannot create a union query with out SQL.

I think the below link will help you in answering some questions you may have on Union queries and also understanding them it bit better.

<a href="http://www.bluemoosetech.com/article.php?jid=21">Microsoft Access Union Queries (Part 1)</a>


I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

RE: Union Queries

Sorry Edward

If the link to my previous post doens't work properly then you can use the below link that should be able to take you directly to the relevant website:

http://www.bluemoosetech.com/article.php?jid=21



I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Access tip:

Undo Entries In Records

To Undo any entries or changes in records:

Hit the ESC key once for the current field

And ESC twice for current record

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.