Summary Total

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Hi,

Is there a way to have SQL to create a query.

I am looking to have query output to :

Meeting Room Total Percentage
Room A 5 14.28% (5 divide by 35)
Room B 15 42.86% (15 divide by 35)
Room C 10 28.57%
Room D 5 14.28%

Total 35

Your help would be much appreciated.
Thanks
 
Bill

What you described sounds more like a report. You can use a query to return
the Room and Total, then build a report that calculates a total of those
Totals, and calculates a Percentage for each Total.

Or, you could build a Totals query, then join that to your Room query to do
the percentage calculations.

Good luck

Jeff Boyce
<Access MVP>
 
Get your data into any version of sql server 2000
(including msde) and use the RAC utility, see
@rpercents (row percents).It's simple, no sql code to write:)

RAC v2.2 and QALite for S2k @
www.rac4sql.net
 
Back
Top