feed query to feed report

[megatronixs]

Hi all,

I have created a report that has sub reports in it. I feed each sub report from a different query. but, for now I have the criteria in those queries hard coded. I would like to know if I can pass the criteria from a field in the form and then when I press a button it will use it to feed the query and get the report open with the results.
Is it also possible to have the report open inside a form? I just was wondering when I wrote these lines.
Is it possible to use the results from 1 query to feed a second one?

Greetings.

 

[Minty]

In answer to your first question - yes http://btabdevelopment.com/how-to-use-a-form-reference-as-criteria-in-a-query/

Yes you can view a report in a form. It sometimes a good way to get variable height display of longer text fields.

Finally - yes one query with criteria can feed another one, with other criteria.

 

[megatronixs]

Hi Minty,

It was easier than expected to get the criteria from a field to the query.
I tried to feed one query with another (as I found some info that you can use one query and enter it in the field name of the query:
https://support.office.com/en-us/ar...subquery-01d7edd6-964e-4372-9334-5e52e4fe4871
but it simply does not work (I have only one field as it says it should).
Is there a simpler way to do this?

Greetings

 

[Minty]

There are a few gotcha's if you are using sub-queries. http://allenbrowne.com/subquery-02.html

I assumed you would be using a saved query to feed another one from your initial description, which can be simpler depending one what you are trying to do.

 

[megatronixs]

Thanks Minty

Greetings.