Newbie Access Help - Query with calculation..

R

rtat

Joined
Jun 14, 2011
Messages
1
Reaction score
0
I have a query that has a [retail_price] and [special_price] field. I need to add a column in the same query that displays the amount of discount in dollars, although IF the [special_price] is '0' then i need the column to display '0'.

Any help would be greatly appreciated!!!

Thanks
Russ
 
Back
Top