To include a check box for resignation in Employee Table?

[Harrold]

Hi

I am a newbie and to create a simple payroll in Access. Would it be useful to create a field by checkbox in employee table for resigned staff? My purpose is to know who to include and exclude for current month payroll.

Thanks

 

[MarkK]

I use a LastDayWorked field. If it is null, then the employee is still working. If I want a list of active employees I do ...

SELECT * FROM Employee WHERE IsNull(LastDayWorked)

 

[Galaxiom]

Yes this is a good idea because it can also give a list of current employees at any time you choose. Handy for things like creating list of those who need a statement of income for the end of financial year. You exclude those who left before the year started.

 

[vbaInet]

A slight tweak to the SQL:

SELECT * FROM Employee WHERE [COLOR=Blue][B][COLOR=Black]LastDayWorked[/COLOR] Is Null[/B][/COLOR];

 

[Harrold]

Hehehe, SQL still beyond my capability. currently, i am still designing my table structure. hopefully, i will be able to use VBA and SQL soon.

Thanks everyone ;-)