Running a query only for filtered records in the underlying table

[AshikHusein]

I am trying to query on a filtered table. The final query is based on another query and that other query is based on the filtered table. However when I run the the query it runs it for the unfiltered table. How can the query run only for the filtered records in the table?

 

[neileg]

Filtering and querying are two ways of achieving the same result. Whatever you are doing in the filter can be done in the query.

Let us know what you are trying to do, and maybe we can help.

 

[AshikHusein]

Details of problem

I will try to explain the problem the best I can here. I am running a report from data imported from a textfile. The report actually runs from a query based on the imported table. The sequence of events is like this:

From the main table -----> Query1
From Query1--------> Query2
From Query2-------> Final Report.

The main table has a field called "Centre" which can be names of diffrent cities. I would like to filter the table for any one centre say "Toronto, and then run the report which should be only for the "Toronto". But when I do this it gives me an unfiltered Final Report.

I hope this makes the problem clearer. Thanks

 

[neileg]

In the appropriate query add a criterion to the Centre field that looks like this
=[Enter the name of the Centre you want to report on]

When you run the report, a box will pop up that asks you to "Enter the name of the Centre you want to report on"

An alternative is create a form and ask the user to enter the name in a text box. The advantage here is you can use a combo box, so that the user is limited to selecting a centre that exists in the database and ensures the spelling is correct.

 

[AshikHusein]

The problem is that when I designed the structure I did not include the field "Centre" for the queries. But cant this work if I query on a filtered data base. I tried to add "Centre" in the queries with some frighteneing results (which included subgrouping in the Final Report). Thanks.