Condition for record to be included in a report

[El Jagang]

The database I'm building will enable my employer to keep a historical record of which staff member has held which job. To that end, I've created a field called [Current Position Holder], with only a "Y" or "N" being acceptable entries.

One of the reports I'm designing should only include the current position holders. Is there a way to make it so only records where [Current Position Holders] is set to "Y" will appear in this report? If so, where/how would I enter such a condition?

 

[namliam]

In the where clause of your recordsource?

 

[arnelgp]

on report design Property->Data->
Filter [Current Position Holders]="Y"
Filter On Load: Yes

 

[El Jagang]

Turns out, all I needed to do was change the Row Source to "Y" only in the field's property sheet. But thanks for the help, folks, it's much appreciated!