Hi, I am trying to calculate the total light fixture order based on the following scenario:
Residential building has several floor plans (UnitTypes) with each floor plan having several light fixture types with various quantities of each type of fixture. I have added a total cost per fixture. Using MS Query I have linked the tables and produced a pivot tables hoping to generate a light fixture subtotal amount. The problem I am finding is that the count of fixtures is not factored into the calculation but rather the instance of the UnitTypes which extends the total for the fixture type. Should I have set up the table for FixtureCounts differently (ie/ line by line by the number of times the fixture appears or null where non existent in the UnitType?) Please see attached. Thank you for your help in advance.
Bookmarks