First, please forgive if this is in the wrong thread. This is being made on a form, has to do with charts, and I think its a problem with the SQL statement... so thats where I focused
Anyway, I run through the chart wizard to create a pie chart, I get to the part where I drag the fields to the chart and it will only allow me to drag one field. Each field I move after that it wants to replace the old with the newly drug field.
So I continue through the wizard and this is the query it builds for me:
SELECT [MilliporeID],[IronAndCarbPercent] FROM [ResultsMillipore];
Another wizard I tried using a query to pull the data from the table:
SELECT [InertsPercent],Sum([HydrocarbonsPercent]) AS [SumOfHydrocarbonsPercent] FROM [ResultsMilliporeChartQuery] GROUP BY [InertsPercent];
Those just wont work, so I build the query myself as such:
SELECT ResultsMillipore.InertsPercent, ResultsMillipore.IronAndCarbPercent, ResultsMillipore.HydrocarbonsPercent FROM ResultsMillipore WHERE ResultsMillipore.MilliporeID = ResultsMillipore.MilliporeIDI think the where at the end is useless as it should only take the information from the currently highlighted record, if I understand it properly, but the value changes appropriately when I move between records on my forms.
So my issue is that the pie chart wont display all my slices, just one of them. Its got to be something with the way the statement is written but I'm not exactly a pro at SQL and this is my first rodeo with Access. When I edit the chart object I can see all my data, but its all on one row.