Query-Criteria field blank

Hi;

Dumb question, but I have a query and i want to accept the record if a field is blank. I
have tried criteria of ="", isempty(Fieldame) and a rich variety of other things with no
joy. How do I accept a record in a query if a specific field is blank?

Thanks

John Baker

re: Query-Criteria field blank

It could be Null, not blank, in which case try IsNull([FieldName])

If it's possibly both Null and blank (i.e.: sometimes it's Null, and
sometimes it's blank) and you want to trap both, try:

Len([FieldName] & "") = 0

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"John Baker" <Baker.JH@Verizon.net> wrote in message
news:q4irk01qaqhe18okado04n8optu3i5626m@4ax.com...[color=blue]
> Hi;
>
> Dumb question, but I have a query and i want to accept the record if a[/color]
field is blank. I[color=blue]
> have tried criteria of ="", isempty(Fieldame) and a rich variety of other[/color]
things with no[color=blue]
> joy. How do I accept a record in a query if a specific field is blank?
>
> Thanks
>
> John Baker[/color]