I know. I am brand new employee at this company. Its only my 2nd week. I havent been given SQL Server 2005 access yet. So for the past week I...

sql = "DECLARE @result1 VARCHAR(50)" & _

"select isnull(User_id, 'Not Available') as UserName, ISNULL(P2_Date_Acknowledged, 'N/A') as Result1 " & _

"from Investment_Advisor ia " & _

"left join Investment_Advisor_Part2 iap on iap.P2_Year_ID =...

i really do appreciate all your feed back just to let you know you have been very helpfull......but as i was just looking at that query. i keep forgetting that...

sqlz = " select isnull(User_id, 'Not Available') as UserName, ISNULL(P2_Date_Acknowledged, 'N/A') as Result1 "

sqlz = sqlz & "from Investment_Advisor ia"

sqlz = sqlz & "left join Investment_Advisor_Part2 iap on iap.P2_Year_ID =...

I will see if that works. When you put..

from Investment_Advisor ia

What does the ia stand for/mean ?

i realize

Response.Write("<td class=fielddHeader valign=top nowrap><b> "&rs("user_name")&"</b></td>")

should be

Response.Write("<td class=fielddHeader valign=top nowrap><b> "&rs("theResult1")&"</b></td>")

....even with this change still doesn't work

ok. here is everything i have. keep in mind again I am tryin to export these results into an excel file. The first query runs fine all the user names...

My purpose here was I wanted to compare rs("user_name") to rs("theResult")

Ok guys I have another question for you. I am using this query:

sql = " select b.User_Name "

sql = sql & " from Investment_Advisor b "

sql =...

How would you display the value of that variable @result, for example in ASP? PLEASE HELP

would it be.....

Response.Write("<td class=fieldFormat valign=top nowrap> "&rs("@result")&"</td>")