Calculated field?

[Tansar]

HI,

I need to create the following:

"S" = 5 days
"M" = 3 day
"N" = 0 days

So if a user selects from a drop down list 1 of the 3 options (S,M,N) then I need to add the number to the present date.

If S then (5 + 3rd June 03) = 8th June 03

How do I tackle this?

TIA

 

[Mile-O]

In a query, make the calculable field:

NewDate: DateAdd("d",IIf([YourOptionField]="S",5,IIf([YourOptionField]="M",3,0)),[YourDateField])