Report filtering

[Guest]

Dear Sirs
* I have a query whereby one field has the possibility to show: Cuenta
gestionada, Cuenta Autodirigidas, Simulación, BIE 30
* Since the datalayout of those different products are different I have to
create minimum 2 Reports from that query.
* How can I, for example, can ask one report only to print the BIE 30 data?

 

[fredg]

Dear Sirs
* I have a query whereby one field has the possibility to show: Cuenta
gestionada, Cuenta Autodirigidas, Simulación, BIE 30
* Since the datalayout of those different products are different I have to
create minimum 2 Reports from that query.
* How can I, for example, can ask one report only to print the BIE 30 data?

You can set the Filter property of the report to:
[FieldName] = 'BIE 30'
Set the FilterOn property to Yes

 

[KML]

Amateur,

There are a number of ways to accomplish this, I will suggest one.

1) Make a copy of your query. Name the query something like
"MyQueryName with Prompt"
2) Open the query in Design View.
3) If it is not there already, add the field that holds your stated
values to the query.
4) In the criteria section, type something like this "[Enter your
value]"
5) Now switch to the Datasheet view. If the query is working properly,
you should be prompted to enter a value. Enter any of the appropriate
values (like BIE 30) and make sure the results are what you are
expecting. Save and exit the query.
6) Create a report using the Report Wizard that is based on the query
you just made. When you open the report, you should be prompted to
enter the necessary value. You should be able to use this report to
produce the sets of data you are looking for.