Filtering fields in reports

[veder]

Hi,
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.

Thanks!
veder

 

[Matt Greatorex]

I'm assuming that there's a field in the underlying table to indicate whether ot not the project is completed? For example, if there is a 'Phase' field and those records with a value of 'X' are complete, you could set the report's record source to be

select * from {tablename} where [Phase] <> 'X';

Alternatively, if the source for the report is a query, just add the

where [Phase] <> 'X'

part to that.

Hope that helps.