Showing blanks in a query

[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

 

[hcj]

criteria for tested field: Is Null

 

[Gary Walter]

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?

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