I got it now, thank you for your help.

Not sure what you mean, I have tried the following:

Declare @Memberid as varchar (50)

Declare @ProcCode as Varchar (15)

set @memberid = -1

Set @ProcCode = 'G0202'

Select top 100 * from [QICC-TEST].dbo.tblClaims_eligible

where Membid...

Perfect, thank you.

I am trying to get rid of the time stamp at the end, that does not do it .

Rick, that works, thank you.

In this case, yes, but the challenge that I am facing is that I freqently get data from an outside source, rather than import it to a table and join...

Lets say that I have the following order numbers that I want to lookup in our favorite database, Northwind:

10248

10249

10250

10251

10252

10253

10254

10255

10256

10257

I want to put this in the following format or somthing like...

It works perfectly!  THANK YOU!

I was talking about the derived table, thank you.

Right now I have tried the following:

1.  Standard copy and paste.

2.  Saving the results to a text file and importing the text file.

3.  Setting up an ODBC link from SQL...

Thank you both, I am not that strong in Access which is why I don't import directly from Access.  As for the setting up the ODBC, that sounds like a...

Thank you for your help, your answer worked.