Sheila,

Use code similar to the following:

If queryID = "SAPBEXq0002" Or queryID = "SAPBEXq006" Then


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"sheila_d_pratt" wrote
in message
...
Hi,

I have the following If statement;

If query ID = "SAPBEXq0002" Then
I want to add another query ID to this statement. I have tried
separating
them by a comma and got an error. e.g. If query ID =
"SAPBEXq0002",
"SAPBEXq006" Then.

What is the best way to write this so that either query can be
used.

Thanks
--
sheila