I am using the following code to query a database for two characteristics that the website user will choose from two drop down boxes. The variables representing those two characteristics are called varColor and varbirthdate. First of all does the following statement look correct, regarding the quotes and & symbols? Also, someone said that if I am using Access (which I am) I should use #'s around the date. If I do that do I still put the & symbols and everything else the same? Do I need to put the number symbols into my actual Access database somewhere? Thank you for your help!<BR><BR> <BR><BR>objCommand.CommandText = "SELECT name FROM fishtable " & _ "Where color = '" & varColor & _ "' AND birthdate = '" & varbirthdate & "'"