structure question on a join file

[Janis]

I want to create a Access query tool with not very much user data entry.

It is for an ISP. It is pretty simple structure I only need weekly data
regarding utilization if it's over 50% for 2 items, tv traffic and internet
traffic which flow through the same modem, optical transmitter and cables.

AreaStationID ---> RouterID-->OpticalTransmitter<--OpticalTxJoinID--->Node
OpticalTransmitter--> Statistics
AreaStation: id, cityName
ModemID: id,router
Optical Tx: id, transmitter
Node: id, node
Statistics: weekending, internet utilization, tv utilization

Question 1: Can I get the weekly data related from the Join file? Is that
the right relationship?
Question 2: I only need the data for the last 6 weeks. I'm not clear on
how to use the db as a query tool? I want to archive the data for each week
but I only need the average for last 6 weeks for a report. So I store the
data from the SQL query in the weekending field for both items in the
statistics table?

Question 3: How do you create an Excel report output from an Access db?

The complication is they split the node if the utilization is over 50% and
move it to a new router. So this will be the only user input.

There could be more than one node on one transmitter. The node is the end
of the cable that feeds the subscribers. The node is the many to many.
When it gets segmented one of the groups of letters gets moved to a different
router.

My question is I'm not quite sure how to show the history when the node gets
split.
Thanks for any suggestions.

 

[Doug M]

You currently have Utilization per Optical Transmitter, but you want to
report on Utilization per Node? Since Transmitter - Node is a many to many
you don't have any way to know what the Utilization per Node is in general,
but if you have a many to many because Nodes may be switched from one
Transmitter to another over time (but are only connected to one Transmitter
at any one time) then depending on how you get your Utilization information
it could be linked to either Node or Transmitter or both.

In other words in your Utilization records you could put both your
Transmitter and your Node if there is only one of each. Then you could
report utilization either way.

Doug