How can I filter an report?

[Guest]

Hi, I have an address table, in the filed of 'Category' , there are
'Organization, Government, and Others', now I wanna to create report for
these three categories respectively, how can I filter the report base on the
category? Thank you.

 

[Duane Hookom]

Create a combo or list box on a form that has a row source of all your
unique Category fields. Add a command button to the form to open the report.
Assuming the combo box is named "cboCategory", modify the command button
code to something like:

Dim stDocument As String
Dim strWhere As String
stDocument = "rptMyReport"
If Not IsNull(Me.cboCategory) Then
strWhere = "[Category] = """ & Me.cboCategory & """"
End If
DoCmd.OpenReport stDocument, acPreview, , strWhere