Using the IIF in a form

[JTKrol]

I'm sorry for all these simple questions...I haven't done anything with access since windows 95... so I am VERY RUSTY and trying to help out the misses....

I am using =DateAdd("d",60,[Dateofhire/term] in the Expression Builder to calculate another date field. But have just been told by my misses for that to be correct they have to be either FTHourly or FTSalary employee types (both are yes/no fields)



Can I use the IIF function to check the value of the [FTHourly] or [FTSalary] fields before it performs this calculation?

If so what is the syntax if there is a better way to do this I'm open to that too.

THANK YOU ALL SO MUCH FOR YOUR HELP!!

[June7]

Yes.

What value(s) are you checking for? What do you want to do if the desired value(s) not encountered?

What field type are FTHourly and FTSalary - yes/no? Why two yes/no fields? Can both be yes in a record? If not, should be 1 field with two options.

[CJ_London]

=iif([FTHourly] or [FTSalary],DateAdd("d",60,[Dateofhire/term]),0)

by the way - bad idea to use / in field names

[JTKrol]

=iif([FTHourly] or [FTSalary],DateAdd("d",60,[Dateofhire/term]),0)

by the way - bad idea to use / in field names

Thank You I'll change it.

[JTKrol]

Worked great, I replaced the 0 with Null because the 0 was giving me a funky date and the Null leaves it blank...THANK YOU