Question: It looks like TPC is greatly underutilizing its available space. Create a query that returns the BuildingName field and a second calculated field named %

It looks like TPC is greatly underutilizing its available space. Create a query that returns the BuildingName field and a second calculated field named %Unused. This second field should calculate the percent of each building's space that is not used. Format the values in this second field as a percent with no decimal places. Sort in ascending sequence by BuildingName. You can calculate the total space available in each building by multiplying its length by its width. Save this query as Query4
 It looks like TPC is greatly underutilizing its available space. Create

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!