Find employee, display name, calculate retirement

[sephiroth2906]

Hello all!

I have an employee database, and one of the things I want it to do is calculate retirement eligibility. What I want it to do is:

When I find the employee I want, I want a label to display their first name and last name by taking the value from Employee_First_Name and Employee_Last_Name from the table.

I then want it to retrieve the birth date from Birth_Date from the table, calculate the age (I actually have that calculation figured out) and display it in another label. Then take the years of service, calculated from Employment_Date and display that (same calculation)

Then I would like to add those two numbers.

Actually, I know how to do most of this if it were entered directly in the form, but I do not know how to fetch this information from the table.

Thanks in advance for the help!

[Stingaway]

I would suggest diving into queries and how to use them. The calculations you would use on the form would be very similar (if not identical) to the ones you would use in the query.

[orange]

As stingaway suggested, use a query to select the data you want from your table. Work with it and develop the calculated fields you need. Save that query.
Then create a Form and bind it to your query.