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.
Thanks a lot,