Thanks for the replies,

Not sure if I am getting the operators correct, since the code is still not working. I coded it to find a transaction on a certain day and that worked.

start = startdate.value (DateTimePicker)
finish = finishdate.value (DateTimePicker)

This code (Below) worked fine.
Code:
Command.CommandText = "SELECT * FROM Transactions WHERE Transaction_Date = #" & start & "#"
However this code didn't:
Code:
Command.CommandText = "SELECT * FROM Transactions WHERE Transaction_Date > #" & start & "# AND Transaction_Date < #" & finish & "#"
Transaction_Date is in the table 'Transactions' and is a field of data type Date/Time.

Thanks.