I'm really hoping someone can help me because I've been beating my head on it for the last hour. I am trying to populate a temporary table (stbl_BWSummary) with statistics for use in a report/graph. My raw data comes from a prebuilt query which contains among other things the network node #, interface on that node, type of interface (serial, Ethernet, etc.) that interface is, the date of the record, and the total amount of bandwidth that went over that interface for the day.
In my temporary table, I am trying to populate a record that shows the aggregate bandwidth (by interface type) for each node ona day. I have a sum query that works just fine.
I am trying to figure out how use that as the basis of an update query to fill in the serial portion of the temporary table. I'd rather not use prebuilt queries because there are multiple interface types this has to happen with and I would rather create the query in VBA and execute instead of saving a ton of different queries. I really appreciate your help.
Troy
In my temporary table, I am trying to populate a record that shows the aggregate bandwidth (by interface type) for each node ona day. I have a sum query that works just fine.
Code:
SELECT qry_InterfaceThroughput.TrainingDay, qry_InterfaceThroughput.Node_ID, Sum(qry_InterfaceThroughput.TotalBW) AS SumOfTotalBW
FROM qry_InterfaceThroughput
GROUP BY qry_InterfaceThroughput.TrainingDay, qry_InterfaceThroughput.Type, qry_InterfaceThroughput.Node_ID
HAVING (((qry_InterfaceThroughput.Type)="Serial"));I am trying to figure out how use that as the basis of an update query to fill in the serial portion of the temporary table. I'd rather not use prebuilt queries because there are multiple interface types this has to happen with and I would rather create the query in VBA and execute instead of saving a ton of different queries. I really appreciate your help.
Troy
