How to make a filter in a report?

[Guest]

I know this may be a odd question considering the number of posts on filters
in reports... but I can't find anywhere a description on how to create a
filter (input box) in the report in the first place.

I have joined the source with a query that contains "total sales" for each
customer and I want to filter the report so that only sales above x dollars
are shown.

I presume there's a way to make a textbox / select list that can be used to
enter the value (sales) and operator (< >) to filter the output (report)?

Kindly,
Mikael
Sweden

 

[Marshall Barton]

I know this may be a odd question considering the number of posts on filters
in reports... but I can't find anywhere a description on how to create a
filter (input box) in the report in the first place.

I have joined the source with a query that contains "total sales" for each
customer and I want to filter the report so that only sales above x dollars
are shown.

I presume there's a way to make a textbox / select list that can be used to
enter the value (sales) and operator (< >) to filter the output (report)?

Report's should not contain their own filtering mechanism if
you can avoid it

Generally, the filter should be applied in the code that
opens the report (usually a commanf button on a form)

stWhere = "[total sales]" & cboOperator & txtSales
DoCmd.OpenReport "report name", , , stWhere