Recent content by Bill HR Specialist

I want a field that I will enter the current work experience of an employee years and months and i would like it to update as time passes. not sure if possible seeing if anyone else has done this. I am willing to accept it displayed as a decimal, i.e 4 years 7 months would be 4.7, I would just...

Since that was not going right found a better way, since my report need 3 months of Birthdays from current on out I used the Month() function instead in the condition: Between Month(Now()) And Month(Now())+2 and it returns what I need. Thanks to a little frustration I avoided needless input for...

SELECT Employees.[Last Name], Employees.[Birth Date], Employees.Facility, DatePart('m',[Employees]![Birth Date]) AS Expr1 FROM Employees WHERE (((Employees.[Birth Date]) Is Not Null) AND ((DatePart('m',[Employees]![Birth Date])) Between [Start Month as Number] And [End Month as Number]));

Okay I have a table with a list of birthdays mm/dd/yyyy in the query I want a parameter condition that asked for birthdays beween Months i.e give me all employees that have a birthday between January and March. I tried doing a DatePart conversion which brought me back just the Month as a number...

Can't go wrong with nude photos...................................................... wait, strike that, you can go wrong with nude photos nevermind

I have a table of employees, I have a table of mandatory classes each employee must take, included in that table are classes that have to be done annually. I need to track what classes are needed to be completed for each employee. Now I have done this before but it was clunky and I know it can...

Hello, experianced Access user but still run into walls, I am retired US Army, now an evil HR Specialist and some of my hobbies are sword fighting, video games, and reading, amongst many other geeky things I do, now to go and ask a question in the proper forum, Ta!