I have text field with 3 possible values: C, F, or Null.
When I query with criteria: Not "C", I get only the F records and not
the Nulls. Is this normal?
Yes. Null is never equal to nor NOT equal to anything else (even another
Null). You need to use...
<> "C" Or Is Null
I have been working with a SQL table through ODBC and when I use Not
"C" on that table I get the F records and the Null records. When I do
it against an Access table with the same field properties I get the
above results.
SQL Server an be configures to handle Nulls in more than one way. The way
Access is handling them is considered the "correct" way.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
RE: Null or No Null values in a parameter query ... IIf([Press ENTER for nulls, 'N" not nulls] Is Null,1,0) test if ... All criteria on the same line must be met -- they are AND'd together. ... I can see that a field called 1 was added to my query with a ..."KARL DEWEY" wrote: ... (microsoft.public.access.gettingstarted)
Re: Median ... so the nulls may be being re-introduced to the ... Run your XPercentile function and your query against that. ... I have not personally used this median function......Candia Computer Consulting - Candia NH ... (microsoft.public.access.reports)
Re: SQL Query with Iff and Wild Card ... That will work as long as your field doesn't contain nulls.... If you need ALL records then try the following criteria... >I am trying to use the results from a form to build an SQL Query.... > used as the selection criteria of the query. ... (microsoft.public.access.queries)
Re: No success with setting query criteria for returning empty ... If there is nothing at all in the Status field for active students,... In the Criteria row under this field in query design,...Nulls behave differently than other types of data. ... (microsoft.public.access.queries)
Re: MailMerge Query Discontinuity ...nulls, zeros and blanks. ... Neither Word nor MS Query seems to be an exception, ... > When the MailMerge Recipents form's Edit control is clicked, ... query result is displayed via a DDE link to Micrsoft Query.... (microsoft.public.word.mailmerge.fields)
