Automatic Calculation of Dates + user entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I want a field to automatically fill in depending upon a selection made
by the user.

If they choose 'High' 7 days is added to the duebydate, if medium is
selected 14 days is added etc.

If Other is chosen, it lets the user input a date, but it will not let me do
this.

The expression I have used is below.

=IIf([priority]='High',[datereceived]+7,IIf([priority]='Other',[duebydate],IIf([priority]='Medium',[datereceived]+14,IIf([priority]='Low',[datereceived]+30,Null))))

Any help would be appreciated.
 
Hi, I tried this
=IIf([priority]="High",[datereceived]+7,IIf([priority]="Medium",[datereceived]+14,IIf([priority]="Low",[datereceived]+30,IIf([priority]="Other","",Null))))

but when i try to enter a date in after selecting Other, the status bar
gives the message "Control can't be edited; it's bound to the expression
(then it gives the expression I used)

Have I done it right?

Thanks again

[email protected] said:
hi,
Replace the single quotes with double quotes.
from ' to "
-----Original Message-----
Hi, I want a field to automatically fill in depending upon a selection made
by the user.

If they choose 'High' 7 days is added to the duebydate, if medium is
selected 14 days is added etc.

If Other is chosen, it lets the user input a date, but it will not let me do
this.

The expression I have used is below.

=IIf([priority]='High',[datereceived]+7,IIf([priority] ='Other',[duebydate],IIf([priority]='Medium',[datereceived]
+14,IIf([priority]='Low',[datereceived]+30,Null))))

Any help would be appreciated.
.
Click to expand...
Click to expand...
 
Back
Top