Another date Querie

[Luddite Lad]

I'm trying to construct a query that will show all fields where the date is greater than today’s date less eight days, and also pick up fields which contain no data.

The first part I have achieved with the criteria >Now()-8

But I've been unable to find the correct syntax for picking up fields which contain no data.

 

[banza]

Try >Now()-8 OR IS NULL

 

[Luddite Lad]

Too easy; thanks heaps