ah hah!  I was trying to make it more difficult than it was  thanks!

Thats it!  thanks for all your help guys  And it worked better yes, by just running the query as a stored procedure and calling...

Hey Phil...when I run this it is asking me to declare r and c.....says variables not declared.    What and where do I declare them?

kristin ...

Hi Phil  thanks for the reply..

1.  The link between records and chains is the specimenID...actually, it is the field I would like to use to...

Not doin so good  hahahah.  now I get this:

################Butalbital#######################Methamphetamine###################

here is the query now..

SELECT records.result, company.company,

    records.firstn + ' ' + records.lastn AS DONOR,...

ok, here is my query and the results I get????

SELECT records.result, company.company,

    records.firstn + ' ' + records.lastn AS DONOR, records.donorid,

    records.collecteddate, records.reason, records.lab,

    records.speciminid,

    REPLACE(REPLACE(ISNULL(records.amphetamine,...

tells me isnull requires two arguments????

what does that mean?

hmmmm, the results still just all run together like:

MethamphetaminePhencyclidineOpiates

here is what I did...

SELECT records.result, company.company,

    records.firstn + ' ' + records.lastn AS DONOR, records.donorid,

    records.collecteddate, records.reason, records.lab,

   ...

I got it to work....but by using Like ?  Doesn't seem to care about upper and lower case, it is returning everything regardless.  Then in my vb command trailing the...

I'm trying not to build the query in VB....  Any idea how to use the wild card with a variable in SQL???  Or how exactly would I use the

"WHERE...

So not letting me send you an email.....  here is mine.

kstariha72 at msn.com

you're my hero  going to shoot you an email right now...

kristin

HAH!  oh my god, this is way over my head  Isn't there a simple way to do this?  We get like 300 faxes in...

Hmmmm, ok, but where am I when I'm saving this file?  I need to create a vb interface to save the file to the table.  do I hook this code...

I'm not scanning the images in, but they are coming in off of a fax server.  And I'm trying to make this application EASY EASY for the girls here in...