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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
Access Running Balance in Access 1
Update Table with query 3
Overflow error on calculate field in query - Help Please 1
How do I add a field to a query and make a calculation? 3
Running Balance (Debit and Credit) in Access 2007 4
DSum update query with multiple fields 0
Using a Yes/No field to trigger a calculation in another field - J 3

Top