Showing blanks in a query

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

What do I type in the design view of a query to make it
show only fileds that have no value in them. I am trying
to make a query of people that haven't recieved records.
When one revieves a record, they put the date in the
query, how can I make it show all the ones that haven't
recieved them?
Thanks,
Rich
 
Rich said:
What do I type in the design view of a query to make it
show only fileds that have no value in them. I am trying
to make a query of people that haven't recieved records.
When one revieves a record, they put the date in the
query, how can I make it show all the ones that haven't
recieved them?
Click to expand...

Hi Rich,

I assume you have a "DateRcvd" field
in your table and you want to return only
the records form your table where that
field is "blank."

In the query design grid, the column
for your "DateRcvd" field might look like:

Field: DateRcvd
Table: yourtable
Sort:
Show:
Criteria: IS NULL

Now "blank" can mean other things
depending on how you have set the
properties for this field in table design.

A "for-sure-find-all-blanks" alternative
might look like (in a separate column):

Field: Len(Trim([DateRcvd] & ""))
Table:
Sort:
Show:
Criteria: 0

Of course, replace "DateRcvd" and
"yourtable" with your field and table
names.

Please respond back if I have misunderstood.

Good luck,

Gary Walter
 
Back
Top