return previous employee

[Guest]

I am hoping to build a database that tracks open positions and employees.
What I would like to be able to do is:
Track who held a position previously. When an employee leaves her current
position for any reason, Department, Position#, Title, (Pay) Grade, Reason
Left, Date Left, Destination will be recorded into a table.

In a report that lists open positions, I would like to see the most recent
person to hold the position. Any thoughts? Thanks.

tj

 

[Guest]

Usin a query, try something like

Select * From TableName Where [Date Left] = DMax("[Date
Left]","[TableName]","[Position#] =" & [Position#])

 

[Guest]

I haven't had a chance to implement this yet. I'll post back with results.
Thank you for the suggestion.
--
tj

Usin a query, try something like

Select * From TableName Where [Date Left] = DMax("[Date
Left]","[TableName]","[Position#] =" & [Position#])

--
\\// Live Long and Prosper \\//
BS"D

I am hoping to build a database that tracks open positions and employees.
What I would like to be able to do is:
Track who held a position previously. When an employee leaves her current
position for any reason, Department, Position#, Title, (Pay) Grade, Reason
Left, Date Left, Destination will be recorded into a table.

In a report that lists open positions, I would like to see the most recent
person to hold the position. Any thoughts? Thanks.

tj