S
sturose2000
I haven't felt this lost since I first started! I've got a medium-sized
database (9 tables), but I've been able to piece together the data by a
query such that my problem simplifies to something similar to the U.S.
Marginal Tax Brackets in concept.
Here's my deal: there are policies from which the user will choose one or
more to plot (easy enough for me to plug thru by a parameter query). The
data involved consists of:
qryPolicy.Tier
qryPolicy.Whose
qryPolicy.Method
qryPolicy.Amount
I also want to include parameters such as:
MaximumValue
Resolution
Ok, so each qryPolicy.Tier has a Floor and a Ceiling. For example, Tier 0
is
money "skimmed off the top," Tier 1 may be $1-$1000, etc. Any given Policy
may have different ranges of Tiers, but the concept is the same. Each
qryWhose tells who gets a given share of the money. For example, in Tier 1
there may be Whose for Joe, Sally, and Mike, while Tier 2 may have only Joe
and Sally. qryMethod just states whether the share is Fixed (e.g. always
$450) or Fraction (e.g. 35% of the Tier). qryAmount is that fixed number or
fraction.
Ideally, a user will select one or more policies, specify a range of
interest with Parameter MaximumValue (e.g. show up to $25,000) and a
Parameter Resolution (e.g. plot intervals of $10 or of $100). Then a Form
or Report (advice here please?) will come up showing a plot with Total
Dollars on the x-axis and Share-Size Dollars on the y-axis, with the various
series referring to different Whose or different Policies.
Each Policy has a different Tier structure, and there may be different Whose
recipients in any given Tier. Basically I want to show that, for example,
if the "whole pie" is $5000, then Joe gets 25% of the first $2000 and 20% of
the next $3000, while Sally gets 75% of the first $2000 and 80% of the rest.
Like I said, it has similar character to the Tax Bracket system.
Do I need to use a MakeTable query to get a list of values at each point
from $0 to $MaximumValue by intervals of $Resolution? Or can I just
temporarily calculate data and plot it without storing it? Can I do this
with VBA? If so, please point me in the right direction. This is turning
out to be more challenging than I had first thought, but once I get started
I think I'll be able to push thru all the extra features it needs.
Thanks in advance,
Stu
database (9 tables), but I've been able to piece together the data by a
query such that my problem simplifies to something similar to the U.S.
Marginal Tax Brackets in concept.
Here's my deal: there are policies from which the user will choose one or
more to plot (easy enough for me to plug thru by a parameter query). The
data involved consists of:
qryPolicy.Tier
qryPolicy.Whose
qryPolicy.Method
qryPolicy.Amount
I also want to include parameters such as:
MaximumValue
Resolution
Ok, so each qryPolicy.Tier has a Floor and a Ceiling. For example, Tier 0
is
money "skimmed off the top," Tier 1 may be $1-$1000, etc. Any given Policy
may have different ranges of Tiers, but the concept is the same. Each
qryWhose tells who gets a given share of the money. For example, in Tier 1
there may be Whose for Joe, Sally, and Mike, while Tier 2 may have only Joe
and Sally. qryMethod just states whether the share is Fixed (e.g. always
$450) or Fraction (e.g. 35% of the Tier). qryAmount is that fixed number or
fraction.
Ideally, a user will select one or more policies, specify a range of
interest with Parameter MaximumValue (e.g. show up to $25,000) and a
Parameter Resolution (e.g. plot intervals of $10 or of $100). Then a Form
or Report (advice here please?) will come up showing a plot with Total
Dollars on the x-axis and Share-Size Dollars on the y-axis, with the various
series referring to different Whose or different Policies.
Each Policy has a different Tier structure, and there may be different Whose
recipients in any given Tier. Basically I want to show that, for example,
if the "whole pie" is $5000, then Joe gets 25% of the first $2000 and 20% of
the next $3000, while Sally gets 75% of the first $2000 and 80% of the rest.
Like I said, it has similar character to the Tax Bracket system.
Do I need to use a MakeTable query to get a list of values at each point
from $0 to $MaximumValue by intervals of $Resolution? Or can I just
temporarily calculate data and plot it without storing it? Can I do this
with VBA? If so, please point me in the right direction. This is turning
out to be more challenging than I had first thought, but once I get started
I think I'll be able to push thru all the extra features it needs.
Thanks in advance,
Stu