469,603 Members | 2,049 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,603 developers. It's quick & easy.

Making a retired employee INACTIVE instead of deleting his/her name from the Payroll

I am developing a payroll program.. The data generated will be saved in an Access Database. I want a situation whereby when an employee leaves the organization or retires, instead of deleting his name from the Payroll it is made INACTIVE. This is to ensure that his/her name does not appear in subsequent payroll.
Oct 16 '06 #1
1 1400
scripto
143 100+
add a bit field to your Access table called Active. All active employees will have a "1" in that column, and all retired employees will have a "0" in the column.

so your select statment will read like:
select * from yourtable where active = 1 (for active employees)
select * from yourtable where active = 0 (for inactive employees)
Oct 16 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Thomas G. Marshall | last post: by
7 posts views Thread by Ivo | last post: by
1 post views Thread by xxbabysue123xx | last post: by
1 post views Thread by tshad | last post: by
reply views Thread by guiromero | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.