Percent of matches

  • Thread starter Thread starter Luis
  • Start date Start date
L

Luis

Hello.
I'm trying to create a querie that does a group by one
field of a certain table and counts the number of
ocurrencies of the records grouped. What i'd like to
include on the output is the percentage of ocurrencies for
those records.
How can i do this?

Thanks
 
Hello.
I'm trying to create a querie that does a group by one
field of a certain table and counts the number of
ocurrencies of the records grouped. What i'd like to
include on the output is the percentage of ocurrencies for
those records.
How can i do this?

Thanks
Click to expand...

Include a calculated field

Pct: (Count(*) / DCount("*", "[yourtable]"))


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top