I've been putting this off for a while now, but I've gotten to the point where I need to ask for help.
First and foremost - I'm very green when it comes to Access and everything I know is self taught with a whole lot of google help.
That said, what I'm working on is a database that among other things, tracks all the server racks in our facility as well as their power usage.
I'm running a query that looks through the Electrical Readings table and pulls the load reading for each circuit assigned to a rack, for whichever server room the user has selected.
Here's what's returned:
The problem is, when I do this for a room which has 40+ racks, my query and associated report become quite long as most of the racks are dual fed. Could I leave it as is and tell them to get out their calculators? Sure - but unfortunately, my customer just wants to know how much Amperage or kW a specific rack is using - not caring about how many circuits are feeding it.
What I'm trying to figure out is how I can effectively, sum all the loads for each rack, so that each rack only has one line - kinda like this:
Any insight/help would be greatly appreciated.
First and foremost - I'm very green when it comes to Access and everything I know is self taught with a whole lot of google help.
That said, what I'm working on is a database that among other things, tracks all the server racks in our facility as well as their power usage.
I'm running a query that looks through the Electrical Readings table and pulls the load reading for each circuit assigned to a rack, for whichever server room the user has selected.
Here's what's returned:
| Rack | Panel | CB# | CB_Rating | Load A | Load B | Load C | Reading Date |
| 409 | UPS01-1 | 30/32 | 20 | 1.40 | 1.40 | 3/11/2021 | |
| 409 | UPS01-1 | 26/28 | 20 | 1.40 | 1.40 | 3/11/2021 | |
| 409 | UPS01-1 | 25/27 | 20 | 1.30 | 1.30 | 3/11/2021 | |
| 409 | UPS01-1 | 21/23 | 20 | 1.40 | 1.40 | 3/11/2021 | |
| 409 | UPS01 | 07 | 20 | 0.70 | 3/11/2021 | ||
| 409 | UPS01 | 05 | 20 | 2.50 | 3/11/2021 |
The problem is, when I do this for a room which has 40+ racks, my query and associated report become quite long as most of the racks are dual fed. Could I leave it as is and tell them to get out their calculators? Sure - but unfortunately, my customer just wants to know how much Amperage or kW a specific rack is using - not caring about how many circuits are feeding it.
What I'm trying to figure out is how I can effectively, sum all the loads for each rack, so that each rack only has one line - kinda like this:
| Rack | Total Amps | Reading Date |
| 409 | 14.20 | 3/11/2021 |
| 410 | 12.00 | 3/11/2021 |
| 411 | 1.30 | 3/11/2021 |
| 412 | 4.00 | 3/11/2021 |
| 413 | 8.00 | 3/11/2021 |
| 409 | 15.00 | 3/11/2021 |
Any insight/help would be greatly appreciated.
