Limiting records that appear in a report

[Kim]

I need to create a report that only includes records (in this case,
Companies) with a Number 1 or 2 in the record. I have a query set up with
the results, but I haven't been able to get the query results into the report.

 

[tedmi]

Set the report's record source to your query.

 

[John W. Vinson]

I need to create a report that only includes records (in this case,
Companies) with a Number 1 or 2 in the record. I have a query set up with
the results, but I haven't been able to get the query results into the report.

A Report has a "Record Source" property which is the name of a Table (probably
what you have), or the name of a Query (which you probably want instead), or
even a SQL string which returns the desired records.

Set your report's Recordsource property to the name of your query and see if
that works.