frmEmployees is the Main form.
txtcurdte is the Current Date
TPayRate is a Subform where their Last Raise Amount is stored.
PayEffDate is a Date Field for the last time a raise was given.On the subform
Example: ? Refer to subform from frmEmployees
[TPayRate].[Form]![PayEffDate]
DateDiff("d",[PayEffDate],[txtcurdte]) 'Almost ? Max ?
txtdayssinceraise = How many Days since last raise.
txtcurdte is the Current Date
TPayRate is a Subform where their Last Raise Amount is stored.
PayEffDate is a Date Field for the last time a raise was given.On the subform
Example: ? Refer to subform from frmEmployees
[TPayRate].[Form]![PayEffDate]
DateDiff("d",[PayEffDate],[txtcurdte]) 'Almost ? Max ?
txtdayssinceraise = How many Days since last raise.
Evaluation Notice
0 commentaires:
Enregistrer un commentaire