AnsweredAssumed Answered

Counting related records

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



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,