Hi Guys,
For some reason i've had a brain fart this afternoon and for the life of me can't remember how to code a is not null section into a SQL statement.
"SELECT * FROM Qsel_WorkstepHours WHERE ((Qsel_WorkstepHours.ClientID)=" & ID & ") And ((Qsel_WorkstepHours.JobStart) is not null) ORDER BY Qsel_WorkstepHours.JobStart ASC;"
I've tried so many combinations of the "is not null" section of the code but cant seem to remember the correct one.
Any help appreciated!
For some reason i've had a brain fart this afternoon and for the life of me can't remember how to code a is not null section into a SQL statement.
"SELECT * FROM Qsel_WorkstepHours WHERE ((Qsel_WorkstepHours.ClientID)=" & ID & ") And ((Qsel_WorkstepHours.JobStart) is not null) ORDER BY Qsel_WorkstepHours.JobStart ASC;"
I've tried so many combinations of the "is not null" section of the code but cant seem to remember the correct one.
Any help appreciated!
