C
ChuckW
Hi,
I have a field called StartDate in a Customer table. I want to create a
table called Commissions that has two fields: DateValue and CommissionRate.
There would be three records. 1,2 and 3 for the DateValue field and 8%, 10%
and 14% for the CommissionRate. I then want to write a query that will
analyze a date range and assign a value based on the StartDate field in the
Customer table. so 3/1/06 to 2/28/07 = 1, 3/1/07 to 2/28/08 = 2 and 3/1/08
to 2/28/09 = 3. I then want to join the values generated from this query to
the DateValue field in the Commissions table. So if someone has a StartDate
of 12/1/06, they have a value of 1 which means they are assigned a commission
rate of 8 %. If someone has a start date of 12/1/07, they have a value of 2
and a commision rate of 10% and if someone has a startdate of 12/1/08, they
have a datevalue of 3 and a commison rate of 14 %. Does anyone have any
ideas of how to do this?
Thanks,
I have a field called StartDate in a Customer table. I want to create a
table called Commissions that has two fields: DateValue and CommissionRate.
There would be three records. 1,2 and 3 for the DateValue field and 8%, 10%
and 14% for the CommissionRate. I then want to write a query that will
analyze a date range and assign a value based on the StartDate field in the
Customer table. so 3/1/06 to 2/28/07 = 1, 3/1/07 to 2/28/08 = 2 and 3/1/08
to 2/28/09 = 3. I then want to join the values generated from this query to
the DateValue field in the Commissions table. So if someone has a StartDate
of 12/1/06, they have a value of 1 which means they are assigned a commission
rate of 8 %. If someone has a start date of 12/1/07, they have a value of 2
and a commision rate of 10% and if someone has a startdate of 12/1/08, they
have a datevalue of 3 and a commison rate of 14 %. Does anyone have any
ideas of how to do this?
Thanks,