If/Then, possibly?

[JeepsR4Mud]

Hello,

I'm doing a query that calculates the number of days between NOW() and the date of hire.

I'd like to have a field called probation, that displays the word probation if the employee has been with the company less than 181 days (probabtion being 180 days).

I think I need an if/then statement, but I'm not sure.

Ideas?

Thanks.

Gayle Ann

 

[Mile-O]

NewField: IIf(DateDiff("d", [StartDate], Date()) <= 180, "Probation", "Permanent")

where StartDate is the name of your current start of employment field.

 

[JeepsR4Mud]

Hello,

I tried it, but it lists ALL the employees as permanent, not just the ones with 180+ days of service.

My actual field is "days in class"

Thanks.

Gayle Ann

 

[Rich]

Post the SQL of your query

 

[JeepsR4Mud]

Figured it out! Thanks!