Reporting on Year Only

  • Thread starter Thread starter JackAtArcLight
  • Start date Start date
J

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.
 
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
 
Problem Solved. Thanks for all of your help.

Jeff Boyce said:
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 said:
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.
Click to expand...
Click to expand...
 
Back
Top