queries and chart help!

[devagupt]

I have another question in queries and charts. I ran a query to count the number of records present in a field and sorted it in ascending order. WHen i make the chart , it doesnt display it in ascending order , i wonder why.Below is the code. I was trying to make a pareto chart which would display our downtime type from the highest to the lowest but for some reason it displays as is.Help please!

SELECT tblDowntimeTable.Shift, tblDowntimeTable.Type01, Count(tblDowntimeTable.Type01) AS CountOfType01
FROM tblDowntimeTable
GROUP BY tblDowntimeTable.Shift, tblDowntimeTable.Type01, DatePart("ww",[tblDowntimeTable]![Date01])
HAVING (((tblDowntimeTable.Shift)=2))
ORDER BY Count(tblDowntimeTable.Type01);

 

[dhookom]

What is the exact Row Source property of the Chart control?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[devagupt]

The Row source property is
SELECT [Type01],Sum([CountOfType01]) AS [SumOfCountOfType01] FROM [DowntimebyType] GROUP BY [Type01];

 

[dhookom]

You don't have any ORDER BY in your Row Source so you can't count on it being in any particular order.

Try:

SELECT [Type01],Sum([CountOfType01]) AS [SumOfCountOfType01] 
FROM [DowntimebyType]   
GROUP BY [Type01]
ORDER BY Sum([CountOfType01]);

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[devagupt]

perfecto! Thanks a lot!