Filter data sheet to show records with no date... (1 Viewer)

[Carpetwarehouse]

Hi just a quick one im sure for you experts. Im having trouble with a datasheet its ran from a macro button using BrowseTo command. Im having trouble with the where condition; i would like to show records where the [FittingDate] is blank...

i have tried isnull() and [FittingDate]=""

 

[pr2-eugin]

How about..

IsNull([FittingDate]) = True

Or

[FittingDate] Is Null