Sorting by Count of Ref and Top N in Crosstab

A

Adam

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
 
A

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.
Click to expand...
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
 
Top