Filtering fileds in a report

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

Guest

I currently have a report that displays a list of projects. One of the fields
within the report is the Project Phase. I am trying to filter out any
projects that are in a "Completed" phase. I am new to using Access, though
and am having trouble setting up the filter.
 
Hi, I hope this stages will help you.

1. Open the report in design view
2. Open the properties (press Alt+Enter)
3. Click on the Top Left side of the report, so the report properties will
be displayed
4. One of the properties called RecordSource, locate the cursor in it
5. On the right side of the propety there is a button with three dots, press
on it
6. Now that you can see the source of the report, that look like a query,
under the field Project Phase locate a criteria
<> "Completed"
 
Back
Top