What is the proper syntax to use a access query

[1712]

I have created a query in access and want to use it in a select statement in my asp code.

I tried to simply do:
select * from query
and it comes back with an error that it could not find the table/query

The whole reason for doing this is because I cannot seem to find the reason why I get an error on the following code

sqlstr = "SELECT * FROM nanny inner join references on nanny.id = references.id"
sqlstr = sqlstr & " WHERE nanny.id = " & request("id&quot

The error says something is wrong with my from statement.

 

[dmhirsch]

Insert...

Response.Write strSQL

...just before the line opening the recordset. Usually it's easier to see a SQL syntax problem after the SQL has been put together, and this trick will display it on the page.

 

[dmhirsch]

And I can't see a problem, at first glance.