Reporting problem

[m17347047711116]

I have a report that has Employees start dates

I would like to print a seniority list of start dates however i do not want to include employees that do not have a value in the start date field. For instance in my employee list when an employee retires i remove his seniority date but do not remove them from the data base as i still need to maintain information regarding benifits ect. When i print the seniority list the employees with no start date value still appear on the seniority list i do not want them to appear, any suggestions?

 

[saintsman]

You need to create an additional field in your table for people who have retired, Then just filter them out with a query.

 

[Pat Hartman]

Use selection criteria for the query. There is no need to add an additional column.
Select ...
From ....
Where StartDate Is Not Null;