Thanks Ray M and Jeremy,

It looks like I can only return a value when using a CASE statement within my where clause.  What if my where clause is different depending upon...

I ended up updating the MDAC and Microsoft Jet files.

The production webserver is pointing to the correct sql server. what do you mean by exposing my web server to the sql server? I thought by stating the username...

Actually, I was looking for the last record that had been inserted with an identity column.

Thank You!

Jenise

Thanks for the advice, I really appreciate it.

I don't have complete code yet, but I meant that I have a set of three drop down boxes within a table layout.

My original thought was that creating a...