Scatter Chart

[eTom]

I'm having a heap of trouble getting a scatter chart working. My report lists records from a query, including AvgDiameter, MinDiameter and MaxDiameter. The chart is supposed to have all three of these as their own series of points.

My problem lies in the X Axis. Ideally I want them simply graphed as point 1, 2, 3, etc. I don't need or want anything further than that. There is a Date and BatchNumber field I could use, but the dates are often the same for a few records which would cause cluster of a lot of points on the same x co-ordinate.

Using BatchNumber isn't an option because they go from things like 00010 to 90022 etc, so the points end up clustered at both ends of the graph with nothing in the middle.

Is there some way I can include just plain old "record number" from the query results? The first one is 1, the second is 2, etc... ? If I use the Count function, I get a total number of records (let's say 10) and every point gets plotted with an X coordinate of 10!

Here is the SQL code for my chart itself, albeit mostly built using the SQL builder, as I'm far from even "moderate" in SQL programming skill!

SELECT [Reports]![MeasurementSummary]![RecordCount] AS Expr1, qryMeasurementSummary.AvgDiameter, qryMeasurementSummary.MinDiameter, qryMeasurementSummary.MaxDiameter
FROM qryMeasurementSummary
GROUP BY qryMeasurementSummary.AvgDiameter, qryMeasurementSummary.MinDiameter, qryMeasurementSummary.MaxDiameter, qryMeasurementSummary.FormulaID
HAVING (((qryMeasurementSummary.FormulaID)=[Reports]![MeasurementSummary]![FormulaID]));

Thanks in advance!