Hi There

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.

Try using "date()" vs. "now()", and "less than" vs. "is not"

Select * from user where user.date < date() and user.activation is null;

Select * from user where [dtmMyDate] < Date() And Not IsNull([activation]);

You shouldn't use date as a variable name because Date() exists as a function. Change it to something else, for example, I called it dtmMyDate. Choose a name that makes sense to you.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks for cleaning and clearing that up Greg.