If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Dates Validation for Overlapping & Gaps (Leo asked)
Hi there,
I need to have a table to keep employees salaries, in which each employee may have many different salaries on different ranges of dates, with fields of EmployeeID , StartDate, EndDate, Salary Amount. For example employee A can have a 2000 $ monthly salary from Jan 1st to Apr 30th , but 2500$ from May 1st to Dec 31st. Data entry could be though a form or directly from table, but there must be a control or constrain over validity of date ranges (the span between StartDate and EndDate) in a way that no two records overlaps each other for the same employee and also no gap between entries. For example if Employee A receive a salary from Jan 1st to Mar 3oth , then the same employee can not have a record of salary for Feb 1st to Apr 30th (overlapping) or Jun 1st to Dec 31st (leave a gap). How can I impose such a control for date validation?? I appreciate your help. -- Thans & Best regards Leo, InfoSeeker |
Thread Tools | |
Display Modes | |
|
|