Sort problem

[HOMMER]

This gives me all the info I want but does not sort by weeknumber. It sorts by the average. I need to sort by weeks for the graph. I tryed all the normal ways of sorting I can think of I know I am n\missing somethie easy...


TRANSFORM Sum(qry_first_hour_weekly.AvgOfGPH) AS SumOfAvgOfGPH
SELECT qry_first_hour_weekly.weeknumber
FROM qry_first_hour_weekly
GROUP BY qry_first_hour_weekly.weeknumber
PIVOT qry_first_hour_weekly.Year;

 

[dekcool]

try this one!

TRANSFORM Sum(qry_first_hour_weekly.AvgOfGPH) AS SumOfAvgOfGPH
SELECT qry_first_hour_weekly.weeknumber
FROM qry_first_hour_weekly
GROUP BY qry_first_hour_weekly.weeknumber
PIVOT qry_first_hour_weekly.Year
ORDER BY qry_first_hour_weekly.weeknumber ____________________________________________________
Invest your time in learning, Not in practicing.

DEK

 

[Transcend]

Hi there

try adding

ORDER BY qry_first_hour_weekly.weeknumber to your
query

Transcend