I would like to run a query across an external db using a value from a
cell as a restriction in the query.

I would like the query to do something like:

SELECT DCMS.NAME
FROM RXC.DCMS DCMS
WHERE (DCMS.DOMAIN='E$1$')

The query attempts to look only for possible values in the external db.
I need to restrict the name values to only the values which exist in
the domain indicated in cell E1.

I'm guessing I can't do this or will need to do it in the vba editor
rather than query builder?

Can anyone help?

Thanks!!!


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements