Filter records in a Report

[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,

 

[Marshall Barton]

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.

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

 

[Keith Wilby]

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,

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

Keith.
www.keithwilby.co.uk

 

[Brian T]

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.

 

[Marshall Barton]

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.

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
<> ""