Counting the interventions and getting the 10 most common

[Pusher]

Hi all
I want to make a query that list street names that have the most interventions in selected date to date time. It’s so I can know what streets are the most problematic. [FONT=&quot]The table that has the list of interventions is IZVESTAJ.[/FONT]

Thanks

Here is my db

 

[Alansidman]

Which fields do you want to count.

 

[Pusher]

Fields ID_RASKRSNICE (Street name) in IZVESTAJ. The list of streets is in the RASKRSNICE table.

 

[Alansidman]

Need to run out for an appointment. Will check back in later today and seek a solution if someone else has not stepped to the plate.

Alan

 

[Alansidman]

I created a query qryStreetCount. Is this what you are looking for?

 

[Pusher]

Thanks that did it How can i limit so it can be just the first 10 most common lines ?

 

[Alansidman]

Open the qryStreetCount in design mode. Click on the Sigma (Greek Letter that resembles a large E). In the option box next to it, change all to 10.

Alan

 

[Pusher]

Don't know where this option box is. I see the sigma and when i click it i get Total in my query row.

 

[Alansidman]

This is how it looks in AC 2007. What version are you using?

 

[Pusher]

AC 2007 Thanks