Print Page | Close Window

MS Access question

Printed From: Main Street Monroe
Category: Voice Forums
Forum Name: The Voice
Forum Description: Monroe, Ohio news, information and opinions
URL: http://voice.mainstreetmonroe.com/forum_posts.asp?TID=2162
Printed Date: May 27 2019 at 8:37am


Topic: MS Access question
Posted By: jrock1203
Subject: MS Access question
Date Posted: Nov 13 2014 at 9:56am
I'm trying to combine 6 smaller queries in Access into one big one - but I can't seem to get it to work.

Is there an easy way to combine queries that doesn't involve a bunch of SQL coding?

Trying to avoid a headache...

help me oh Access gurus


-------------
Insults are the arguments employed by those who are in the wrong. - Jean-Jacques Rousseau




Replies:
Posted By: Upper90
Date Posted: Nov 13 2014 at 1:59pm
Hello, you should be able to copy and paste your select statements and then use a simple UNION ALL statement in between them. The article below walks you through it. I am not a SQL script writer but over the years have mastered the art of copy and paste from the computer generated scripts after you do a query. People now think I am a master report writer when in fact I am but a common thief!

http://support.office.com/en-us/article/Combine-the-results-of-several-select-queries-by-using-a-union-query-3d4fd525-e5ac-4245-99b3-4f4b66cdb2a1" rel="nofollow - http://support.office.com/en-us/article/Combine-the-results-of-several-select-queries-by-using-a-union-query-3d4fd525-e5ac-4245-99b3-4f4b66cdb2a1




-------------


Posted By: jrock1203
Date Posted: Nov 14 2014 at 9:18am
Thanks. Nailed it :-)

-------------
Insults are the arguments employed by those who are in the wrong. - Jean-Jacques Rousseau




Print Page | Close Window