Formula Question

[drock99a]

I am making a report of problem calls we recieve in the help desk. Each month I give a report of these calls. Is there a formula out there that can tell the user the top problem of the month by looking at the problem field in table1?

 

[SydneyGeek]

Depends. If the problem field is just a whole wodge of text, it would be tedious to search for key words and rank them. If you have a list of options to choose from without free-form text, it can be easily handled with a query. A bit more info, and we may be able to get you started.

Denis

 

[drock99a]

The information I am wanting to pull is location numbers. The location number is located in table1 in the LocID field. These numbers consist of four to five digits that define that particular location.

 

[Norie]

Why not just use a count?

Eg

SELECT TOP 5 [Table1].[LocID], Count([Table1].[LocID]) AS [CountOfLocID]
FROM [Table1]
GROUP BY [Table1].[LocID]
ORDER BY Count([Table1].[LocID]) DESC;