I have a table that identifies costs by Location and Department. I would like to build/run a query that identifies information by the Location and Department (as shown below).
Building Electric Department Plumbing Department Roofing Department Etc.
A $ $ $ $
B $ $ $ $
C $ $ $ $
D $ $ $ $
Etc. $ $ $ $
I assume that DSUM is the best method. Can anyone assist?
Thanks