Reporting on Year Only

[JackAtArcLight]

2 questions:

1. I have a table containing employee hire and termination dates, and would
like to have a report that specifies the year of hire only. How do i pull
those results into a query?

2. I would also like to have a years of experience by subtracting the year
of hire from the current year. Is there a formula for doing this?

thanks in advance for your help.

 

[Jeff Boyce]

In a query, you can add new (calculated) fields.

For example, if you wanted "year of hire", you might use something like
(untested):

YearOfHire: Year([EmployeeHireDate])

.... and to calculate years on-the-job (notice I didn't figure years-worked =
years-of-experience), perhaps:

YearsOnJob: Year(Date()) - Year([EmployeeHireDate])

You may want to rethink that latter one, though, unless you are only
interested in folks with one or more years. If you want to know "months of
experience" instead, take a look at Access HELP for the DateDiff() function.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[JackAtArcLight]

Problem Solved. Thanks for all of your help.

In a query, you can add new (calculated) fields.

For example, if you wanted "year of hire", you might use something like
(untested):

YearOfHire: Year([EmployeeHireDate])

.... and to calculate years on-the-job (notice I didn't figure years-worked =
years-of-experience), perhaps:

YearsOnJob: Year(Date()) - Year([EmployeeHireDate])

You may want to rethink that latter one, though, unless you are only
interested in folks with one or more years. If you want to know "months of
experience" instead, take a look at Access HELP for the DateDiff() function.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

2 questions:

1. I have a table containing employee hire and termination dates, and
would
like to have a report that specifies the year of hire only. How do i pull
those results into a query?

2. I would also like to have a years of experience by subtracting the
year
of hire from the current year. Is there a formula for doing this?

thanks in advance for your help.