Sorting by Count of Ref and Top N in Crosstab

[Guest]

Hi All,

I'm a newbie at Access queries, especially Crosstab queries.

I have a crosstab query that has the categories running down the left and
dates running across the top with a Count of Call ref in the data area.

I have three questions.

How can I get it to sort the categories on the left in descending order by
the count of call ref?
Also how can I get it too group the dates running across the top by Month?
Finally how can I do a top 10 records for this by the high count of call ref
recorded by category on the left.

Many Thanks

 

[Andi Mayer]

Hi All,

I'm a newbie at Access queries, especially Crosstab queries.

I have a crosstab query that has the categories running down the left and
dates running across the top with a Count of Call ref in the data area.

I have three questions.

How can I get it to sort the categories on the left in descending order by
the count of call ref?
Also how can I get it too group the dates running across the top by Month?
Finally how can I do a top 10 records for this by the high count of call ref
recorded by category on the left.

gives us the SQL String, without it we have to write a Novel to
explain you everything

If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW