If you are not using between then you need to put the field name in twice like this:

Code:
strSQL = "SELECT * FROM tbl_Finances"
strSQL = strSQL & " WHERE Finance_Date > #" & dtDateOne & "#"
strSQL = strSQL & " AND Finance_Date < #" & dtDateTwo & "#"
strSQL = strSQL & " ORDER BY Finance_Date"