Sorting Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 20 fields called Rounting01, Routing02,......Routing20. When cables
are being routed the user inputs into a form the Cable Tray that the cable is
being routed in. For instance, A cable desingation called PV100 maybe located
in CabLE Tray CT01 (Route01) which is then routed into another cable tray
CT01 (Route02) and then to Cable Tray CT03 (Route03) and so on.

What I want to do is have a report that shows me what cables are in each
particular cable tray, but as in the example above; depending upon how the
actual cable is routed the information store could be in all different
combinations; in other words CT01 isn't necessarily always stored in
Route01...It could be in Route02 or 03 or 04...etc. I need the report to
look at all the routings inputs and then extract all the cables that are in
CT01 and then in CT02 and then in CT03 and so on....

Any ideas?????

thanks for the help!
 
My suggestion would be to normalize your tables. You shouldn't have a
repeating group like Routing01, Routing02, etc. Instead, that should be a
second table that has 1 row for each relevant entry (i.e.: if there are 3
trays involved, you'd have 3 rows, if there are 20 trays involved, you'd
have 20 rows).
 
Heiko said:
I have 20 fields called Rounting01, Routing02,......Routing20. When
cables are being routed the user inputs into a form the Cable Tray
that the cable is being routed in. For instance, A cable desingation
called PV100 maybe located in CabLE Tray CT01 (Route01) which is then
routed into another cable tray CT01 (Route02) and then to Cable Tray
CT03 (Route03) and so on.

What I want to do is have a report that shows me what cables are in
each particular cable tray, but as in the example above; depending
upon how the actual cable is routed the information store could be in
all different combinations; in other words CT01 isn't necessarily
always stored in Route01...It could be in Route02 or 03 or 04...etc.
I need the report to look at all the routings inputs and then extract
all the cables that are in CT01 and then in CT02 and then in CT03 and
so on....

Any ideas?????

thanks for the help!
Click to expand...

As Douglas said, you should normalize the database and add an additional
table.

It would be possible, but not pretty to do what you want without doing
that, but it will be a lot easier in the long run to normalize it. Access
is not a spreadsheet and related tables is the big difference. It is the
right tool for your kind of data but you are not using those features.
 
Back
Top