Date problem

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

Guest

I have a query that calculates commisions paid from an install date up to 91
days after the install date. How can I calculate the commision for a
particular sale up to the 91 days and continue to be in the query results
after the 91 days with no commision calculated. Basically showing that the
commission has been completely paid. The query I have will have the sales
commision on it until the 91 days are up them once past the 91 days it wont
be in the query results any more.

Thanks for your help in advance.
 
I have a query that calculates commisions paid from an install date up to 91
days after the install date. How can I calculate the commision for a
particular sale up to the 91 days and continue to be in the query results
after the 91 days with no commision calculated. Basically showing that the
commission has been completely paid. The query I have will have the sales
commision on it until the 91 days are up them once past the 91 days it wont
be in the query results any more.

Thanks for your help in advance.
Click to expand...

Modify your Commission calculation to include the IIF() function, and have
it do the evaluation of within 91 days and return either the commission or a
0. It could look something like this:

Commision: IIF([InstallDate]-[OrderDate]<=91,{existing commission calc},0)

where {existing commission calc} is the logic you are using for determining
the commission.

Rob Schneider
 
Back
Top