logic and <

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

Guest

H

Im am trying to work out the following
Employees have a base salary of 30,000, and for each years experience they get another 3000. However they cannot receive more than 150,000. How would I do that in a query
Much appreciated
 
Is there a field for hire date? Are there business rules that describe the
method for calculating years of experience? Is there a table name and
perhaps some other field names? Could you provide about 5 sample records
with a column containing the calculated salary?

--
Duane Hookom
MS Access MVP
--

Greg said:
Hi

Im am trying to work out the following:
Employees have a base salary of 30,000, and for each years experience they
Click to expand...
get another 3000. However they cannot receive more than 150,000. How would I
do that in a query.
 
Iif([YearsOfService] < 40, 30000 + 3000 * [YearsOfService], 150000)

--
HTH
Van T. Dinh
MVP (Access)


Greg said:
Hi

Im am trying to work out the following:
Employees have a base salary of 30,000, and for each years experience they
Click to expand...
get another 3000. However they cannot receive more than 150,000. How would I
do that in a query.
 
Back
Top