Sorting out number of calls by field type

[supportt]

I am in the process of writing a query, but need a little help. We have a ticket DB, where users log calls for customer problems. Well, I need to create a monthly report for the calls. I have a field called Call_Type, which list all the possible Call Types, I would to be able to create the query based on the top 25 Call Types. In other words, if I have 100 Call Types, I would like to see the Top 25 that had the most Calls related to them....

Any suggestions?

Thanks

 

[Mile-O]

Not knowing anything about your table structure all I can say is this:

In SQL, you can use the TOP keyword:

i.e.

SELECT TOP 20

 

[dcx693]

If you want the top 25, use a top values query. Create a query as you normally would, listing all the call types. Then go to the query property sheet in design view (do that by going to the View menu and choosing Properties - make sure it's the query property sheet by looking at the title bar for the sheet and verifying that it says "Query Properties"), in the line that says "Top Vaules" enter 25. Make sure you choose a sort order for the call types, then run the query to verify it works.

 

[supportt]

Maybe I was not so clear

If you want the top 25, use a top values query. Create a query as you normally would, listing all the call types. Then go to the query property sheet in design view (do that by going to the View menu and choosing Properties - make sure it's the query property sheet by looking at the title bar for the sheet and verifying that it says "Query Properties"), in the line that says "Top Vaules" enter 25. Make sure you choose a sort order for the call types, then run the query to verify it works.

That only gave me the first 25 rows, that is not exactly what I was looking for. Let me try this example: Say I have 100 tickets for this month, out of the 100 tickets, there were 20 for Call Type System Unavailable, 25 for 045 Error, 10 for PC Down, 1 for Monitor Problem...well out of all 100 tickets, I just want to see the Call Types that had the most activity, but only the top 25 call types. Hope this is a little clearer

 

[Mile-O]

First do a Count in the query on the thing you're counting, and then select the Top 25 as stated.