Follow Main Street Monroe: Facebook Twitter

 
  New Posts New Posts RSS Feed - MS Access question
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

MS Access question

 Post Reply Post Reply
Author
jrock1203 View Drop Down
Prominent Voice Citizen
Prominent Voice Citizen
Avatar

Joined: May 22 2013
Location: Monroe
Status: Offline
Points: 1542
Post Options Post Options   Thanks (0) Thanks(0)   Quote jrock1203 Quote  Post ReplyReply Direct Link To This Post Topic: MS Access question
    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

Back to Top
Upper90 View Drop Down
Voice Citizen
Voice Citizen
Avatar

Joined: Jun 18 2009
Status: Offline
Points: 630
Post Options Post Options   Thanks (2) Thanks(2)   Quote Upper90 Quote  Post ReplyReply Direct Link To This Post 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


Back to Top
jrock1203 View Drop Down
Prominent Voice Citizen
Prominent Voice Citizen
Avatar

Joined: May 22 2013
Location: Monroe
Status: Offline
Points: 1542
Post Options Post Options   Thanks (0) Thanks(0)   Quote jrock1203 Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

The Voice | Weather | Advertisers | Advertising Information | Lending Library | Monroe Church Directory

Archived Monroe News From: 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011

Website Design © Xponex Web and Media Services | Contact | Terms of Use | Copyright ©2012 MainStreetMonroe.com