Calculating workdays on form

[Dr_Worm]

Hi,

Help with Access 97! (Access XP sometime in the future) ray:

I need to calculate some dates, they need to be weekdays. What we know is the date the product has to leave the factory, what we want to do is enter that date on a form. After the “FinishDate” is updated three other dates are calculated if needed.
The first one is “PolishFinish” which will use the following calculation (I need help with the syntax);
If PolishShop = “X”, Then
PolishFinish = FinishDate - 2 working days, Else
PolishFinish = “-“

Is it possible to have nested formula’s on a form? If so, what would be the syntax for: If, ElseIf formula?

“Rise up in the cafeteria and stab them with your plastic forks”

 

[Ziggy]

Try this in the control source for a text box (ie.Named: Polishfinisher)

=IIf([PolishShop ]="X",FinishDate - 2,"-")

Meaning:

=IIf([PolishShop ]="X",TrueCondition,FalseCondition)

Ziggy