J JJT Registered User. Local time Today, 12:59 Joined Jan 5, 2001 Messages 47 Jun 23, 2003 #1 I need help with the following: If TYPE = c THEN NEWDATE = DATE + 15 ELSE DATE = DATE + 30 Thanks....much
I need help with the following: If TYPE = c THEN NEWDATE = DATE + 15 ELSE DATE = DATE + 30 Thanks....much
R Rich Guest Jun 23, 2003 #2 Use a calculated field on a form or in a query NewDate:Iif([Type]="C",Date()+15,Date()+30)
