Hi again everyone,

I'm working on being able to subtract the cost of returns against the cost of shipping.

The formula would go something like this

Program ID: IIf([REPORTING_STATE_TYPE]=RETURN_RECEIPT,”make the number a negative”, ([REPORTING_STATE_TYPE])


Thanks for your Help

Do you want to permanently make the number negative? That is not necessary. Just use subtraction in your code or query formula.

What is the function or subroutine you are using with this code?



mmcdonal