Help with SQL query

Someone Please Help!!! I have a table in my Access database that has two columns: name and url. I'm trying to develop a query that simply prints the items in the name field, but when you click on the name, that will go to the items corresponding url field. There's gotta be a way to do this without manually. Long story short, I want to link to urls, but I don't want people to see the urls. I want them to see the names.

Something like this should work:

SQL_query = "SELECT * FROM tablename"
RS.Open SQL_query, conn, 3

<a target=_new HREF='<%=RS("URL")%>'><%=RS("name")%></A>