Filter records in a Report

  • Thread starter Thread starter Brian T
  • Start date Start date
B

Brian T

I am creating a report to show the status of a facility. I have a table
set-up with the information about the facility. One of the fields is named
Event and would like to filter out the records with no event happening.

Thanks,
 
Brian said:
I am creating a report to show the status of a facility. I have a table
set-up with the information about the facility. One of the fields is named
Event and would like to filter out the records with no event happening.
Click to expand...


Create a query based on the table and use the criteria:
Is Not Null
under the event field.

Then change the report's record source to the query
 
Brian T said:
I am creating a report to show the status of a facility. I have a table
set-up with the information about the facility. One of the fields is
named
Event and would like to filter out the records with no event happening.

Thanks,
Click to expand...

Use a query to filter out nulls in that field and then base the report on
the query.

Keith.
www.keithwilby.co.uk
 
Still can't get it to filter. Would the data type in the Event field matter?
I have look-up table to pick the event type.
 
Brian said:
Still can't get it to filter. Would the data type in the Event field matter?
I have look-up table to pick the event type.
Click to expand...


If the field is a Text type, then it might have its
AllowZeroLength property set to Yes. In that case, the
field's value may be "" (zero length string). To deal with
that, it would be best to turn the AllowZeroLength property.

If you can not or are unwilling to do that, then I suggest
the you add a calculated field to the query using an
expression like:
Nz(Event,"")
with the criteria
<> ""
 
Back
Top