One option would be to create a query based on the relevant table
then add a calculated field to the query. You would then use the query
as the record source of the form. You could also put a calculated control
on the form, but, depending on the design of the form, the query
may be the better choice.

It's difficult to give much advice on how to calculate the value you
need since we don't know anything about your tables/data, but it
might look something like the following (as a calculated field
in a query);

EligibleDate: IIf([EmployeeType] = "Full Time", DateAdd("d", 30, [HireDate],
DateAdd("d", 90, [HireDate]))

(the above would be all on one line in the field row of a column in
the query design grid).
--
_________

Sean Bailey


"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,