In the criteria for HEAT type in:
IS Null or [Enter an "X" for Owner Heat, Leave blank for Tenant
Heat]
Dawn Crosier
Application Specialist
"Education Lasts a Lifetime"
This message was posted to a newsgroup. Please post replies and
questions to the group so that others can learn as well.
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf Of Gary E. Daniels
Sent: Wednesday, March 22, 2006 8:50 AM
To: [email protected]
Subject: [ms_access] Choosing a "NULL" value
Hi. Need help on this Query. I have a field called HEAT. It either
contains an "X" or nothing (NULL). I am trying to write a Query to
search only for records with HEAT marked with an "X" or with "NULL" or
empty
string (""). I want it to prompt the user to enter an "X". If nothing
is
entered or anything other than an "X" entered, then only the records
with NULL are displayed. In the Criteria row for the HEAT field I have
"[Enter an "X" for Owner Heat, Leave blank for Tenant Heat]". This
works when an "X" is entered. If nothing is entered or anything besides
an "X" is entered, no records are displayed. Is there some type of "If,
Then", or "Else" statement that could be used so when no "X" is entered
only records with a NULL in the Heat field are displayed?
Thanks in advance.
Gary
Gary E. Daniels
Cornerstone Appraisal Company
500 Selkirk Drive
Schaumburg, IL. 60194
847 882-5892 Fax 847 882-5963
mailto:[EMAIL PROTECTED]
http://www.askdata.net
Yahoo! Groups Links
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
