I am trying to select records from a specific month that the user asks for. The dates are entered with the data type date/time...I need lots of help. I think it should look something like this

SELECT * FROM Account WHERE [ColumnName] = @MM/YYYY?

Please Help

Ozie Pela

Ozie,
Try:

SELECT *
FROM Account
WHERE Month([ColumnName]) = 1

hope it works
jm

THANKS IT WORKS!!!

Ozie Pela