How to make a filter in a report?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mikael Lindqvist - 05 Nov 2007 08:07 GMT

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

Reply to this Message

Marshall Barton - 06 Nov 2007 00:05 GMT

>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
[quoted text clipped - 6 lines]
>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

Signature

Marsh
MVP [MS Access]

Reply to this Message