Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Union Queries

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Union Queries

Resolved · Low Priority · Version 2003

Reply Thu 22 Jan 2009, 15:10Delegate Edward said...

Edward has attended:
Access VBA course
Access Intermediate course

Union Queries

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

For upcoming training course dates see: Pricing & availability

Reply Mon 2 Feb 2009, 11:55Trainer Rajeev said...

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

Reply Mon 2 Feb 2009, 11:59Trainer Rajeev said...

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 articles

· It Is Important To Take Care Over Primary Key Assignment
· What You Need To Know About New Security Features In Access 2007
· How To Create Navigation Forms In Microsoft Access
· Take an Access Course to Learn About Relational Databases
· What Is The Database Documenter And How Is It Used?

Please browse our web site to find out more about
microsoft/access/training/courses and other Microsoft training courses.

Access tip:

Combo box for finding records

You can use a combo box in a form to look up a record. If you place the comb box in the Form header, by then selcting they a field type from the drop down loist, you will see the record for it

View all Access hints and tips