This post answers the question, but I can't figure out how to apply
the model displayed to my scenario.

http://groups.google.com/group/micro...b4836984fd768e

I created named ranges, and get to the point of: "Replace the
displayed SQL code with an adapted version of this:",

Now, all bets are off.

My named ranges on the 4 worksheets a
BG
Chicago
Lisle
Schaumburg


This is the code that appears in the SQL query window:

SELECT BG.`Most Recent Employer`, BG.`Start Date`, BG.`Last Name`,
BG.`First Name`, BG.Title, BG.`Previous Employer`, BG.Title1,
BG.`Email Address`, BG.`BBB Office`, BG.Consultant
FROM BG BG
ORDER BY BG.`Most Recent Employer`

How do I create as the author describes as "an adaped version of
this"?

I'd like to get it to work. but how should the SQL code look with the
additional named ranges added? Having trouble figuring out the
nomenclature.

Many thanks, for anyone who'd like to have a gander at this.


Rick