Laura Sheldon
asked on
Access 2007, Using a Null value to change another field to 0
Using the following, I'm trying to force a 0 value into the [BillDt-BillPd] field if the [Bill Paid Date] field is empty. I've tried Null as is demonstrated, 0, IsNull before [Bill Paid Date] & NZ before [Bill Paid Date], none of which worked.
Over30: Iif([Bill Paid Date]=Null,[BillDT-BillPd] =0,IIf([Bi llDt-BillP d]<30,0,II f([BillDt- BillPd]>30 ,[BillDt-B illPd]-30) ))
Thanks,
Over30: Iif([Bill Paid Date]=Null,[BillDT-BillPd]
Thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER