godseyj
05-16-2002, 07:07 AM
Trying to make a query for report. Need to create my own field by adding Field: "this should be my statement"
basically I want this field to be a date minus so many days from another field I have called [Loss Date] this is what I have but doesnt work
TO BN: iif([Type Award] Like ('ARCOM') Then [Loss Date]-90) Or iif([Type Award] Like ('MSM') Then [Loss Date]-120)
My loss date is when someone leaves, the type award is Due "TO BN" on so many days before the loss date depending on "Type Award" I have looked in the Access Help and I cant find the right way to use the Iff function or if there is another function I should use instead Please help!!! Thanks
[This message has been edited by godseyj (edited 05-16-2002).]
basically I want this field to be a date minus so many days from another field I have called [Loss Date] this is what I have but doesnt work
TO BN: iif([Type Award] Like ('ARCOM') Then [Loss Date]-90) Or iif([Type Award] Like ('MSM') Then [Loss Date]-120)
My loss date is when someone leaves, the type award is Due "TO BN" on so many days before the loss date depending on "Type Award" I have looked in the Access Help and I cant find the right way to use the Iff function or if there is another function I should use instead Please help!!! Thanks
[This message has been edited by godseyj (edited 05-16-2002).]