E eri Guest Feb 15, 2004 #1 I have tried to use =IIf([Delivery]>40,40) to change numbers greater than 40 to 40 and have numbers less than 40 remain unchanged.
I have tried to use =IIf([Delivery]>40,40) to change numbers greater than 40 to 40 and have numbers less than 40 remain unchanged.
J Jack Cowley Registered User. Local time Today, 21:50 Joined Aug 7, 2000 Messages 2,639 Feb 15, 2004 #2 In the queries Update To: line try IIF([Deliveries] >40, 40, [Delivery]) hth, Jack
