Counting Query

[Pusher]

Hi all,

I have a table that has a type of device linked to a crossroad street. There are 10 different devices and many streets. I want to make a query that has the type of device and the number of devices on all the streets.


Thanks

 

[vbaInet]

The following link should give you some pointers:

http://office.microsoft.com/en-us/access-help/count-data-by-using-a-query-HA010096311.aspx

 

[Pusher]

Thank you

 

[vbaInet]

No problemo!