Query Question(good challenge)

I am querying a table and filtering it by 2 fields: 1) Name and 2) Date

I can query with field but I do not know how to query by 2 fields.

Much appreciated,
Tom

SELECT * FROM YourTable WHERE [Name] = 'Tom' AND [DATE] = '1/20/2004'

Or

SELECT * FROM YourTable WHERE [Name] = 'Tom' AND [DATE] = #1/20/2004#

SELECT * FROM YourTable WHERE [Name] = 'Tom' AND [DATE] = '1/20/2004'

Or

SELECT * FROM YourTable WHERE [Name] = 'Tom' AND [DATE] = #1/20/2004#


does it matter whether I use -'- or -#-?

Depends on what database you are using. # for Access, ' for SQL Server

access. Thanks man! You saved my day.