Select statement

Hi
I'd like to write a select statement to an access database,

Here is howe the db looks like;

Events (Ev_id, event, show1, date, date1, title)

I have a link on a page (evall.asp) that calls (ev.asp), the link looks like this <A HREF="ev.asp?EvId=<%=allEvents("EV_ID")%>" target="_blank"><%=allEvents("Title")%></A>

nEvId = Trim(Request("EvId"))
The sql looks like tis;
sqlStatement = "SELECT DISTINCTROW view_event.*
FROM view_event " & _
"WHERE (((view_event.EV_ID)=" & nEvId & "))"

This works fine, but if i want to add another term it wont work.

For ex. first the link; <A HREF="ev.asp?EvId=<%=allEvents("EV_ID")%>,?EvTime= <%=allEvents("show1")%>" target="_blank"></A> <%=allevents("title")%>

nEvId = Trim(Request("EvId"))
nEvtime=Trim(Request("EvTime"))
The sql; sqlStatement = "SELECT DISTINCTROW view_event.*
FROM view_event " & _
"WHERE (((view_event.EV_ID)=" & nEvId & ")), (((view_event.show1)=" & nEvtime & "))"

It returns a syntax error ."COUNT Field error"

Can anyone please help me with this?

Best regards Marquis

Try

The sql; sqlStatement = "SELECT DISTINCTROW view_event.*
FROM view_event " & _
"WHERE (((view_event.EV_ID)=" & nEvId & ")) And (((view_event.show1)=" & nEvtime & "))"