Queries

T

Tia

I use a form to display a report and a subreport. The form applies a filter
(that is saved as a query) to the report. When I open the query, the correct
records are shown. However, when I apply it to the report, it is not
filtering the records and displays all records in the report. What am I
doing wrong???
 
T

Tia

The report and subreport have a query as the record source. When you open
the report/subreport, it displays all the records.

In order for us to use it in the office, we need to pull records according
to weeks. So we created filters and saved them as queries, which we apply to
the report. These work except they need to filter data according to
Employee, Week, and Service type. I can get the filter to sort the Employee
and week and the service in the actual query but when I apply it to the form,
it doesn't distinguish the service type and displays all records for that
week, regardless of type of service.

Am I doing something way wrong??? Any suggestions, would be greatly
appreciated!! Thanks!
 
Top