I want to calculate percent in to my report

[a.phoenix]

Hello guys,

I want to calculate percent in my report but I don't know how to do.

example : I want to know male age between 6-13 is how many percent of male
and age between 14-17 how many percent of male



Thanks you..
A. phoenix

[Bob Fitz]

Perhaps something like:

Iif([M6to13]=0,0,([M6to13]/[GT6t013])*100)

for the percentage of Male 6-13

[Bulzie]

Here is a percent value I have in one of my queries, maybe can use with your fields:

PercentComplete: Format(((nz([DeptTotal_Accepted],0)+nz([DeptTotal_Declined],0))/[DeptTotal]),"0%")

[a.phoenix]

Thank you so much, Bob Fitz
it's work very well.

and Thank Bulzie for your answer.