Perhaps something like:
Iif([M6to13]=0,0,([M6to13]/[GT6t013])*100)
for the percentage of Male 6-13
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
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%")