M
MenloP3
Hello,
I'm working on creating an xy scatter plot using 2 combo box selections
representing X and Y coordinates.
In this one form, I have two combo boxes representing, X and Y, that contain
a number of variables: density, elastic moduli, strength, etc. I want the
user to be able to pick two different variables and plot them. For instance,
the user can pick Density for the X variable and Elastic Moduli for the Y
variable.
Below the combo boxes is a query table of the materials, MaterialName, that
the user has already selected and wants to compare. And below this table is
a button "Open Report". When the user clicks on "Open Report", I want Access
to do the following:
-Focus on the selections of ComboX and ComboY
-Have hidden unbound textboxes to store ComboX and ComboY variable selections
-Create a new Query
-Query contains a column of names, Where Field1=MaterialName (legend items)
-Query contains a column of X points, Where Field2=ComboX (X-axis)
-Query contains a column Y points, where Field3=ComboY (Y-axis)
-Plot variables in an XY scatterplot with the axes and legend labeled
correctly
I'm not sure how to even approach this. Could someone please offer
suggestions? Do I require SQL knowledge? Is this even possible in Access?
Thank you for your time.
I'm working on creating an xy scatter plot using 2 combo box selections
representing X and Y coordinates.
In this one form, I have two combo boxes representing, X and Y, that contain
a number of variables: density, elastic moduli, strength, etc. I want the
user to be able to pick two different variables and plot them. For instance,
the user can pick Density for the X variable and Elastic Moduli for the Y
variable.
Below the combo boxes is a query table of the materials, MaterialName, that
the user has already selected and wants to compare. And below this table is
a button "Open Report". When the user clicks on "Open Report", I want Access
to do the following:
-Focus on the selections of ComboX and ComboY
-Have hidden unbound textboxes to store ComboX and ComboY variable selections
-Create a new Query
-Query contains a column of names, Where Field1=MaterialName (legend items)
-Query contains a column of X points, Where Field2=ComboX (X-axis)
-Query contains a column Y points, where Field3=ComboY (Y-axis)
-Plot variables in an XY scatterplot with the axes and legend labeled
correctly
I'm not sure how to even approach this. Could someone please offer
suggestions? Do I require SQL knowledge? Is this even possible in Access?
Thank you for your time.