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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab report problem 6
Excel Filter Listview userform VBA 0
Filtering subreports on main report 0
Need help with combo box lookup reference in a report 6
Filter Report from a ComboList list 2
Filter Sub Report 3
Filtering by most recent date in a report 2
Problem filtering reports 1

Back
Top