IIF statment

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is what I'm trying to do,
I'm calculating a commission based on a [price]field. I want the returned
value to be based on, if the value accured before or after a surtain date
from the field [date completed]
 
Here is what I'm trying to do,
I'm calculating a commission based on a [price]field. I want the returned
value to be based on, if the value accured before or after a surtain date
from the field [date completed]
Click to expand...

Where do you get the commission rate from?
How about the date? Where does that come from?
If everything is hard coded:

=IIf([DateCompleted]<=#11/30/2004#,[Price]*.10,[Price]*.12)
 
Here is what I'm trying to do,
I'm calculating a commission based on a [price]field. I want the returned
value to be based on, if the value accured before or after a surtain date
from the field [date completed]
Click to expand...

Perhaps (with your familiarity with your data) you understand this...
but I certainly don't. What do you mean by "based on"? What is
different before or after the date? What is the expression used to
calculate the commission before, and what after?

John W. Vinson[MVP]
 
TThat worked great, Thanks a million.

fredg said:
Here is what I'm trying to do,
I'm calculating a commission based on a [price]field. I want the returned
value to be based on, if the value accured before or after a surtain date
from the field [date completed]
Click to expand...

Where do you get the commission rate from?
How about the date? Where does that come from?
If everything is hard coded:

=IIf([DateCompleted]<=#11/30/2004#,[Price]*.10,[Price]*.12)
Click to expand...
 
Back
Top