Several Table, need the total discount
 

I have several tables RED, BLUE, YELLOW and TOTAL DISCOUNT
I need to calculate the greatest amount of the three and give a total
discount.
EX. 2ND DAY=$5, 3RD DAY=$7, TODAY'S PRICE=$8
TOTAL DISCOUNT WOULD EQUAL 2ND DAY (SINCE ITS THE LOWEST) TO TODAY'S PRICE =
$5-$8=TOTAL DISCOUNT=$3
and in the same respect, I need to show that if TODAY'S PRICE is the lowest
to equal TOTAL DISCOUNT=ZERO

Several Table, need the total discount
 

Hi

=Yellow-MIN(Red,Blue,Yellow)

--
Regards
Roger Govier



"STUMPED" wrote in message
...
I have several tables RED, BLUE, YELLOW and TOTAL DISCOUNT
I need to calculate the greatest amount of the three and give a total
discount.
EX. 2ND DAY=$5, 3RD DAY=$7, TODAY'S PRICE=$8
TOTAL DISCOUNT WOULD EQUAL 2ND DAY (SINCE ITS THE LOWEST) TO TODAY'S PRICE
=
$5-$8=TOTAL DISCOUNT=$3
and in the same respect, I need to show that if TODAY'S PRICE is the
lowest
to equal TOTAL DISCOUNT=ZERO