View Single Post
Old 06-27-2007, 05:15 AM   #4
Alc
Newly Registered User
 
Join Date: Mar 2007
Location: Ontario
Posts: 2,283
Thanks: 47
Thanked 27 Times in 26 Posts
Alc will become famous soon enough Alc will become famous soon enough
Got it!

I had to Union query the results of six separate queries, but it worked.

In case it's of any use to anyone else, the result looks like this:

Code:
(SELECT 
   Top 10 Amt_From,
   Amt_To,
   Group_Name, 
   Group_Priority, 
   Person_Name, 
   Branch, 
   ID_Number
FROM 
   [Qry_Conf_Lead_Board]
WHERE
   Group_Name = 'ATLANTIC')
UNION
(SELECT 
   Top 10 Amt_From,
   Amt_To,
   Group_Name, 
   Group_Priority, 
   Person_Name, 
   Branch, 
   ID_Number
FROM 
   [Qry_Conf_Lead_Board]
WHERE
   Group_Name = 'QUEBEC')
UNION
etc.
etc.
Thanks for the pointer, MStef. Made all the difference.
Alc is offline   Reply With Quote