Best way to perform math functions

[Accessosaurusrex]

I would like to know how best to address performing basic math functions from queries from a single table. I have one table that I run a query to get a certain group of data from. I am attempting to get a percentage so the way I do it is count how many records I have with one criteria and then how many of the same records I have with additional criteria and then perform simple percentage calculation on a report. I have been experimenting a bit but wind up getting more complicated each time. What would you suggest to be the easiest method to achieve this goal? Thanks.

 

[Trevor G]

Create a query and then use groupings, you can set to count on a field you then have the bases you need to work with an expression to get the percentage.

You can set criteria to exclude or just include items.

If you need help, then consider uploading a sample of your database so someone can take a look, remove/replace any sensitive data