How do I group and count contents of each group?

[Chris Mitchell]

I have a data table that contains among others 4 columns, where the many
(200) locations in column A are connected to the many (650) locations in
column E via one or more of 3 gateways, columns B, C & D. This table
contains in excess of 65K rows.

There are multiple connections between any 2 locations via one or more
gateways, but each connection only passes through one gateway.

All locations in A do not connect with all locations in B via all gateways,
i.e. the matrix has gaps in it.

For each location in A I want to be able to count the number of connections
to all connected locations in E via B, C & D, i.e. the total number of
connections from location A1, A2 etc via each gateway.

To compensate for my lack of experience with Access I would like to build a
Query or Report to do this. But how?

I appreciate there may be other, better, ways of doing this but my
SQL/Visual Basic/coding skills are non-existent and I feel that if I can
build a Query I'll stand some chance of understanding how it works.

 

[Stefan Hoffmann]

hi Chris,

For each location in A I want to be able to count the number of connections
to all connected locations in E via B, C & D, i.e. the total number of
connections from location A1, A2 etc via each gateway.

As SQL:

SELECT ColumnA, Count(*)
FROM yourTable
GROUP BY ColumnA


mfG
--> stefan <--