Re: When a field being queried is blank?

Thanks Allen. I now understand the differences. I guess what I have is a 0
string. That field is not an unknown, I know that it is not associated with
that record. If I create a possible item called "NONE" there is an
AutoNumber and everything works as long as they enter "NONE" for the search
criteria. However, it seems silly for them to type "NONE", I'm sure there is
a more elegant way around this, I just don't have the experience to know what
it is.

"Allen Browne" wrote:

Look at the suggested link.

It discusses how to handle outer joins between the tables, as well as the
critieria.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Phil" <Phil@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ECF0B097-75AE-4F72-A97D-193F17D56978@xxxxxxxxxxxxxxxx
Thanks Allen, but I didn't include all the data because I didn't think it
was
neccessary. Being refreshed, I think my probelm is the table I'm
querying(?)
only contains identifiers (Auto Numbers) from other tables or empty
fields,
blanks. Because these identifiers are meaningless to others they query
with
words listed in another table that are related by Auto Number to the table
I'm interested in. There is no Auto Number for a "blank". So when they
query a "blank" there is no corresponding Auto Number in my table of
interest
and therefore no matching records.

"Allen Browne" wrote:

Explicity include the nulls in your criteria.

For example if you have criteria of:
Not "New York"
use:
Is Null OR Not "New York"

More info:
The Query Lost My Records!
at:
http://allenbrowne.com/casu-02.html

"Phil" <Phil@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DF55FE9C-7520-47DE-8262-C429FCEB2A5D@xxxxxxxxxxxxxxxx
Everything is working except when I query a field and the desired
record's
field is blank. I get nothing. If I put something in that field and
then
query that field for what I put in (I'm querying a couple of fields)
then
it
works. I assume it has something to do with what a blank field is
stored/represented as.


.

Relevant Pages

  • Re: When a field being queried is blank?
    ... Allen Browne - Microsoft MVP. ... only contains identifiers (Auto Numbers) from other tables or empty fields, ... query a "blank" there is no corresponding Auto Number in my table of interest ... Is Null OR Not "New York" ...
    (microsoft.public.access.queries)
  • Re: need help creating criteria for time
    ... Allen Browne - Microsoft MVP. ... I then removed the criteria and left everything else and ran it ... Now let's verify that these date/time fields have *only* date or time, ... If you switch your query to SQL View (View menu, ...
    (microsoft.public.access.queries)
  • Re: a query to produce sales activity totals
    ... The query generates a row for each salesperson, ... Allen Browne - Microsoft MVP. ... of the sales process, including the number of sold and delivered vehicles. ... put these totals into a spread sheet that shows each salesperson's ...
    (microsoft.public.access.queries)
  • Re: Problem with Send Object
    ... Inserted into criteria of report query: ... How are you passing that filter string to the report, ... Allen Browne - Microsoft MVP. ...
    (microsoft.public.access.formscoding)
  • Re: >> Current Items only
    ... I didn't get the bit about needing a UNION query. ... Allen Browne - Microsoft MVP. ... Assuming a RowSource like this: ... To do this I have the combobox recordsource listing all items. ...
    (microsoft.public.access.formscoding)
Quantcast