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
<*> 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/
