Filter a report in 2010

[trumpetman]

I am using Access 2010 and the contact template database. I know that there are standard reports in the main tab. One of them is the Contact report and when I run that report it brings up all the contacts. If I want to select one job title contacts for example Business Development Managers, is there a away I could do this?



Thanks for the help in advance.

[Robeen]

One way you could do that is look at the Report's Property Sheet -> Data Tab -> Record Source property.
If it is a query, you could add:
. . . Where JobTitle = "Business Development Managers"
to the Criteria of the SQL - or just "Business Development Managers" - if you are working in design view in the query designer.

Then - when the report runs you will only see those records.

[amrut]

Use a command button to open the report with the code below
DoCmd.OpenReport "rptName", acViewPreview, , "[fieldname]='" & FilterCriteria & "'"
The report will show only matching records. Note the single quotes around filter criteria assuming the fieldname is text type