I have an asp query pulling data from an access database.
What I need to do is display the data as follows
if value="ABC" then display it as "XYZ"
if value="DEF" then display it as "TUV"
I'd like to do this in the query in access and then just have my asp script point to the query for the data, or I can reformat the data in the asp script with i guess with something like the following:
<% if (rs.Fields("Customer").Value)= "ABC" then %>XYZ <% else =(rs.Fields("Customer").Value)%>
<% if (rs.Fields("Customer").Value)= "DEF" then %>TUV <% else =(rs.Fields("Customer").Value)%>
But this doesnt seem to work as I get an an unexpected next message or syntax error.
Any help is appreciated.