This should be easy????

[bassispunk]

I have a report that groups people by city. how do i calculate the percentage of the total people listed from one city to the total people included in the whole report? It seems this should be simple but I'm not figuring it out. Thanks in advance...

 

[capri]

I haven't done any mathematical calculations yet in my databases, but wouldn't you use the COUNT function?

I just had a quick look at the help for it and found "Count the number of records in each group in a report"

I would assume you fo a COUNT for the number in each city, then do a separate calculation
to calculate the Percentage of the whole similar to excel. There's also "Ways to perform calculations in a query" in the Help section.

 

[bassispunk]

thanks for your reply. i'll try it out.