Help with delete query please

[pekimojoe]

i want to create a delete query that deletes a row if a date is before a certain time... EXCEPT for when the date value is null...

I have the deletion of the dates correct and fine but cant work out how to make an exception in the criteria for blank fields...

For example my criteria is: Where; <=#30/04/2016# EXCEPT if value IS NULL...

I have tried putting a second criteria of "IS NOT NULL" but it still wants to delete everything.

[June7]

If the date value is null then it does not meet the criteria and record will not delete. At least that's what happens for me.

Your date is in international format. That might be an issue. Review http://allenbrowne.com/ser-36.html

However, don't see how that can contribute to records with Null deleting.

Post the full SQL statement.