logic and <

[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

 

[Duane Hookom]

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
--

Hi

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.

 

[Van T. Dinh]

Iif([YearsOfService] < 40, 30000 + 3000 * [YearsOfService], 150000)

--
HTH
Van T. Dinh
MVP (Access)

Hi

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.