Employee Hire Date (1 Viewer)

[Daxton A.]

What is asked of me to do is for Access to tell when an employee has reached 30 days, 60 days, & 90 days. Now I know how to do something like it in excel but I don't know what the formulas or anything that I would use in Access would be.

Daxton

 

[sportsguy]

search on DateDiff using the search drop down in the blue bar above the thread

sportsguy

 

[Daxton A.]

Thank You SportsGuy

That fixed part of my problem but what I need is to take the date difference from now back until the hire date automatically where it isn't having to be entered in everytime it just tells automatically how long it has been since the hire date.

Is there a formula that tells you the current date where it doesn't have to be entered in everytime it is calculated. I know what the one for excel is "=Now()".

 

[sportsguy]

Same as Excel, Word, PP, Access

=Now() in access also. . .

 

[Daxton A.]

Thank You SportGuy

You have been very helpful to me. Very!