By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,949 Members | 890 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,949 IT Pros & Developers. It's quick & easy.

Query-Criteria field blank

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <Ba******@Verizon.net> wrote in message
news:q4********************************@4ax.com...
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.