Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DateDiff Help!
What a excellent thought! This is a much better way of handling these updates. Thank you all for your time; Much Appreciated!- NavVet
- Post #8
- Forum: Microsoft: Access Queries and JET SQL
-
DateDiff Help!
Thank you for your reply. I will read up on your suggestion.- NavVet
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
DateDiff Help!
Yes I will be storing the Tier in my table. Basically, if the employee has been here over 4 years (based on their hiredate) assign a Tier "2" and if less than 4 years assign "1' to the Tier Level.- NavVet
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
DateDiff Help!
Hello everyone!, I am having a bit of trouble producing the results I need. I am trying to assign a tier level based on the persons hire date. If they have been here less than four years from today's date it will assign a "1" value or else "2". What I have below is not producing the results I...- NavVet
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
