H
hawk_2001
Hello all. First-time post.
I am looking for some help with creating a custom graph. But first, let me
give you some basics of what I have and what I am trying to accomplish.
I have a simple margin calculator. The user specifies a desired margin,
fills out several "costs" fields, and the calculator provides a static figure
showing how much revenue is needed to achieve the desired margin based on the
total costs.
One key component on this form is a field I have called "Fuel Price." I am
trying to figure out how I can show, on a graph, how a fluctuation in the
fuel price will affect my margin.
For example, if fuel is at $3.35/gallon, I want a graph that will show what
my margin will be at $2.35/gallon all the way to $4.35/gallon.
I am having trouble figuring out how to get Access to "create a table" with
the information I need in order to draw a graph from.
Any help/suggestions are greatly appreciated!
I am looking for some help with creating a custom graph. But first, let me
give you some basics of what I have and what I am trying to accomplish.
I have a simple margin calculator. The user specifies a desired margin,
fills out several "costs" fields, and the calculator provides a static figure
showing how much revenue is needed to achieve the desired margin based on the
total costs.
One key component on this form is a field I have called "Fuel Price." I am
trying to figure out how I can show, on a graph, how a fluctuation in the
fuel price will affect my margin.
For example, if fuel is at $3.35/gallon, I want a graph that will show what
my margin will be at $2.35/gallon all the way to $4.35/gallon.
I am having trouble figuring out how to get Access to "create a table" with
the information I need in order to draw a graph from.
Any help/suggestions are greatly appreciated!