I get an error of unterminated string in this line:
Response.Write("<a href=""<% =rs.Fields.Item('Order_Tracking').Value%>"">Track Now</a>")
What did I miss?

<%
If VIPPtracking = "" then
    Response.Write("<a href=""<% =rs.Fields.Item('Order_Tracking').Value%>"">Track Now</a>")

else
    Response.write("")
End If

%>

You can't use <% inside code (only in the HTML)...try this:

Response.Write("<a href=""" & rs.Fields.Item('Order_Tracking').Value & """>Track Now</a>")


Peter
------------------------------------------------------
Work smarter, not harder.

I see. Thanks.
Now, if I would want to display the order traking link wherever is available in the list of records and leave blank where not would I need to loop this if statement?

I changed the code so it would display an order tracking link unless there is no tracking link listed for that company; then it displays "No Address". I have about 50 companies to display about 30 of them has a package tracking link provided.
The first displays with "No Address", the second displays "Track Now" even though it does not have a link provided and the rest of the list displays as "No Address" What do I miss?
Here is the code:
<%
If VIPPtracking = "" then
    Response.Write("<a href=""" & rs.Fields.Item("Order_Tracking").Value & """>Track Now</a>")

else
    Response.write("No Address")
End If

%>