Hello, yes I will have the below fields that you mentioned.

"KARL DEWEY" wrote:

You omitted some information so I will guess. You need a HireDate and
Eligible field with the number of days, or a category for eligiblity.

With Eligible field having number of days for eligibility --
Benefits Eligible: IIF(DateDiff("d", HireDate, Date()) = [Eligible],
"Yes", [Eligible] - DateDiff("d", HireDate, Date()) & " Days")

For a category in the Eligible field then you need an IIF statement to
translate category to days or a table to do it if you have a lot of different
possibilities.

--
Build a little, test a little.


"dar" wrote:

Hello-
I would like to see how I can add a calcualted field to my forms that would
show me when an employee is eligible for benefits. I have employee who
qualify in 30 days, others are 90 days.

Your help is appreciated!
Thank you,