Im having a nightmare trying to write this SQL query
I have three fields
I want to exclude records where startdate is in this month
and exclude records were repeatdate is in this month
but include records where repeatdate is null
and include all records where active=1
tried for 2 hours, maybe im doing something wrong, but i cant get the AND and the ORs to work at all when testing for the NULL
tried recordset filter after the query , but it doesnt like it.