Filter on reports

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

Guest

How do I filter different branches stock on a stock report in access 2000.

Ie. I want to print seperate stock reports for the different branches.

Ta
 
Put a button on your form to open the report.

In the Click event of the button, use the Branch field to filter the report.

For an example of how to use a WhereCondition to filter the report when you
open it, see:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html
 
If you have your form open in design view, and the Event tab of the
properties box contains no items, you have the wrong item selected on the
form.

Select your command button. The title bar of the Properties box will not
indicate you are viewing the properties of the command button, and you will
see the On Click property listed on the Event tab.
 
Thanks, done this but the button does nothing.

I control the stock of a preowned vehicle company and have 3 branches where
the vehicles are spread over. I have created a report that lists all the
stock held by the 3 branches. In my table I have a coloumn that lists the
branch name where the stock item is displayed. This is the coloumn I want to
filter in my report?

I hope this makes it easier to understand?

Thank you again.

Ronald Fouché aka
accesscrazy
 
The article provides the information you need, but it may be that there are
other things you need to understand about Access before you can implement
it.
 
Back
Top