C
cjwenngatz
I'm new to Access so please bear with me. I currently have information
on a multitude of construction projects that is broken down by cost
type.
ie:
project 1 - cost type 1
- cost type 2, etc
project 2 - cost type 1
- cost type 2, etc
What I'm trying to do is take one cost type, and add the that for
every single project, into one sum. Then take that sum and average it
out on the total sq footage of those projects.
I've created the query to search for each cost type, but how do I
create this calculation to avg the cost?
on a multitude of construction projects that is broken down by cost
type.
ie:
project 1 - cost type 1
- cost type 2, etc
project 2 - cost type 1
- cost type 2, etc
What I'm trying to do is take one cost type, and add the that for
every single project, into one sum. Then take that sum and average it
out on the total sq footage of those projects.
I've created the query to search for each cost type, but how do I
create this calculation to avg the cost?