Total Query

[joannakf]

I want to write a query that shows me how many Task Chairs and Work Stations are in each building..



This query tells me how many of each office type are in each building:
BuildingLargeSmallWkst124530220450314611004440705180100

This table tells me how many task chairs and workstations go with each office type
Office TypeTask ChairCore WorkstationLarge11Small33Wkst44



How would I write the query in design view?

thanks!

[joannakf]

That didn't work, here is a PDF