[bazango]

Using

<%
SqlJunk = "SELECT * FROM study1 WHERE ID = '"&i&"'"
%>

I get a "type mismatch" error. If I change ID to a text field in Access, it works just fine, but I really need it to be autonumber. Sorry to ask another ignorant question. Help?

for numbers you do not need single quotes the following query should work just fine

"select * from study1 where id = " & i

[bazango]

You'd think I'd of tried that, wouldn't you? Works perfectly! Thank you so much! A mazillion.