asp page using sql string for a to find records.

I created the following sql string using access design view to open a recordset.

SELECT Authors.last_name, Books.title, Books.category
FROM (Authors INNER JOIN Books ON Authors.author_id = Books.author_id) INNER JOIN Publishers ON Books.publisher_id = Publishers.publisher_id
WHERE (((Books.category) Like "Halacha") AND ((Authors.author_id) Like "*") AND ((Books.book_id) Like "*") AND ((Publishers.publisher_id) Like "*"));

I then pasted it into the asp page like this:

sqlstr"SQL STATEMENT HERE"
rs1.open sqlstr,3,3

Doesn't work. I tried replacing the "" with ''.
Didn't help.

My objective is to use values from a form in this sql string and allow the user to navigate the database.

What do you suggest. And please hurry. I've got a deadline!

Thanks in Advance