AnsweredAssumed Answered

Counting related records

Question asked by mennomulders on Jun 5, 2012
Latest reply on Jun 6, 2012 by mennomulders

Hello,

 

I have a problem with counting related records in the following database, which is used for inspecting fire hydrants, valves monitors e.d.

 

The database consists of a a table with companies and a table of items. These tables are related by a company number.

 

The items have an ITEM ID, and a type letter ( A for hydrant, B for valve, C for monitor and so on until T)

 

What I would like to see in the Company record is the total amount of items (so I used the count function, is working great), but also the amount of items sorted by type. I don't even know if is is possible but it sounds so simple, however, I can't figure it out.

 

Any help?

 

Thanks a lot,

Outcomes