More than one label for X axis

[Guest]

Hi,
I have a chart/graph that I want to display accident information on.
At the moment I have it working well except for one annoying issue.
I want it to display the Street AND the Suburb that the accident occurred
e.g Military Rd Neutral Bay, or Military Rd Mosman etc.

I can only get it to display one of the above i.e. Street OR Suburb.
It becomes a bit confusing when 3 or 4 Military Rds, (for diiferent Suburbs;
it's a long road), show up on the chart with no idea of the Suburb.

The Row Source is as follows:

SELECT [Accident Location Count Query].[Acc Location], [Accident Location
Count Query].[Suburb], Sum([Accident Location Count Query].[CountOfAcc
Location]) AS [SumOfCountOfAcc Location] FROM [Accident Location Count Query]
GROUP BY [Accident Location Count Query].[Acc Location], [Accident Location
Count Query].Suburb ORDER BY Sum([Accident Location Count Query].[CountOfAcc
Location]) DESC;
[Accident Location] is the street name.

I'm using Access 2000.

TIA,

KevinT

 

[Al Campagna]

Kevin,
Pretty hard to say without actually seeing the report, and the query behind it, but...
"shooting from the hip"...
You should be able to concatenate the two values together in your chart query
ColumnHeading field...
= [Acc Location] & " " & [Acc Suburb]
and use that value for the X axis labeling.