filter reports

[nashr1928]

I would like to be able to filter by selection only in reports. This would be to separate customers when looking at reports. The way it is now, I have to scroll thru the pages to find the correct report page.

[pbaldy]

This type of thing?

http://www.baldyweb.com/wherecondition.htm

[nashr1928]

Im not sure if that would work. I have one report but it has over 100 pages and each page is a record from a form. I can easily look at the table the form gets its info from and filter by selection lets say 77 records for the customer named Intel. I would like to do that to be anble to get to the correct customer on the report then print it by selecting only that page on the print menu. Like print from page 36 of 36 then you get only that one you need.

[blackbox]

guys, i want filter my monthly report, i have a marketing reports, can i make it appear only this month's activities? in my table i make a due date table, how to filter the report? so the report only shows this month's task, thanks a lot..

[pbaldy]

You can use the appropriate functions here:

http://www.pacificdb.com.au/Support/...hfunctions.htm

Along with a Between clause and the Date() function.

[jkj115]

go to the layout view of the report, click the field you want to filter by, then under Home on the ribbon, select filter