C
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.
(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.