I need to run an SQL query which will select all records before the current date only if a field is null.
Goes something like
Select * from user where user.date is not now() and user.activation is null;
At the moment cannot get anything to work although I've got records in that exist with null activations created before before today.
I think my syntax is wrong. Have tried to create query using Access designer but this doesn't work either.