create query to bracket years in database field

[dreaming]

I am a newbie to Dreamweaver and am trying to figure out if it (or I) can create a bibliography search engine. I have managed to create a basic page with a form that searches author and keyword but am having trouble adding a search for years. I found a description on the Macromedia support page that provides an example but it doesn't seem to be working for me. Below is the SQL query I have in my Recordset dialog box. Any suggestions? The error statement is: [Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query expression.

SELECT AuthorNames, Keywords, Citation
FROM literature
WHERE Keywords LIKE '%listKeywords%' And AuthorNames LIKE '%listAuthor%' AND Year BETWEEN #listStartYr# AND #listEndYr#

[Zaphod Beeblebrox]

Remove the #'s if the field Year is a numeric field.

[mattglet]

Are those ASP variables you are trying to use in your query?

(listKeywords, listAuthor, listStartYr, listEndYr)