How to make a filter in a report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Mikael said:
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)?
Click to expand...


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
 
Back
Top