Thank you all...NIck, TK and Vacation's Over
You are most helpful.
J_J

"Nick Hebb" wrote in message
oups.com...
Yes, there is a query builder available in Excel. From the menu choose
Data Import External Data New Database Query.

It will walk you through a wizard for selecting the data source and the
tables, then present you with a QBE grid (QBE = query by example).
There's an 'SQL' toolbar button that you can click to enter the SQL
manually.

You can also play around with SQL by writing data access code in VBA.
The help files are pretty good for showing some basic stuff.

If you don't have a database to use (e.g. Access or SQL Server), you
can just use Excel as a data source. In another Excel file, create a
grid of data with row headings. Then define a name for the range. When
you use the Import External data wizard I mentioned above, select the
Excel file as your data source.

HTH,

Nick Hebb
BreezeTree Software
http://www.breezetree.com