B
Branko
In order to avoid entering rates for each month
individually, I would like to have a table with the
following structure:
RevType | FromMonth | ToMonth | Rate
----------------------------------
1 3 5 1.25
1 6 7 1.05
2 2 4 1.3
etc.
It basically defines that the rate for Revenue number one
for months March - May is 1.25, June and July is 1.05, ...
Need a query that will have rate for each month as a new
recod:
RevType | Month | Rate
1 3 1.25
1 4 1.25
1 5 1.25
1 6 1.05
1 7 1.05
2 2 1.3
2 3 1.3
2 4 1.3
Any ideas apreciated. Thanks.
individually, I would like to have a table with the
following structure:
RevType | FromMonth | ToMonth | Rate
----------------------------------
1 3 5 1.25
1 6 7 1.05
2 2 4 1.3
etc.
It basically defines that the rate for Revenue number one
for months March - May is 1.25, June and July is 1.05, ...
Need a query that will have rate for each month as a new
recod:
RevType | Month | Rate
1 3 1.25
1 4 1.25
1 5 1.25
1 6 1.05
1 7 1.05
2 2 1.3
2 3 1.3
2 4 1.3
Any ideas apreciated. Thanks.