Dividing two fields by row in a query for a percentage

[Bentley]

Hello,



I am creating a query that requires dividing two fields that are not number or currency based. I have set up counts for each field, however, I do not know the expression to achieve the percentage when trying to divide the counts from the two fields by row.

Any suggestions?

Bentley

[ranman256]

in the query: Pct: [field1]/[field2]
format the cell or report box for percent.

[Bentley]

I understand that part. Where the issue lies is counting non text fields, I have two fields that need counts then divide those numbers to get the percentage. I have names of workers and want to divide the type of task performed by the count of passed.

[John_G]

What are the expressions you have used to get the counts, and do you have aliases for them?

Are you using a totals query?

[Bentley]

I used a duplicate of each field (for the counts). I switched to a totals and changed the total to expression. This seemed to fix it.

Thanks,

Ben