How do I set up an expression in query using IIf Then and >?

W

Wendy - Memphis

I am trying to create an expression in Access to calculate the following...

If [Total Commission] > 20000 then ([Total Commission] - 20000) * [% Profit
Share]

How do I create using the > sign and then calculating from there to get my
final result?
 
K

KARL DEWEY

You can use the below in the query design view grid.
Profit_Share: IIf([Total Commission] > 20000, ([Total Commission] - 20000) *
[% Profit Share], 0)
In this expression there will be no profit share if commision is less than
20000.
 

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

Help with long if then statement 1
Nested IIF Statement syntax(?) problem 4
Using If expressions with an Or expression, and a Count question 10
Nested IIf: Define ranges, >= And <=? 2
IIF in Crosstab Expression 0
Desperately needing help... 4
query too slow 1
Error in IIf Expression 5

Top