Percentage calculation

[BayesTex]

Hi everyone,

I am very confused about calculation inside grouping data.
I need to calculate a percentage using a total outside one group.
I mean, I have:

Inside group:
AreaBasal Percentage
12.5 4.3%
Frecuencia Percentage
8 ?

Outside group:
Total
436

I need to obtain the percentage value (?) from Frecuencia/Total?
I am trying to do this, but it doesnt work, getting error or nothing.

Thanks in advance,

 

[john471]

So you have AreaBasal working, but not Frecuencia ???

Don't know if this is the cause your problem or not...

By default, Access will name the text fields with the same name as the data field, e.g ef you are adding it from the field list. This has caused me much confusion (and errors) in the past. Now I usually name the text boxes with a "txt" prefix, and ensure I reference the appropriate one....

eg add a field from the field list and you will get
(textbox) Frecuencia with value = (datafield) [Frecuencia]

If you then go ahead and change the value to Frecuencia/total, you will get an #Error, because Access sees this as a circular reference, referrring to the textbox in its own calculation. Change the name of the text box, eg to txtFrecuencia, and the circular reference goes away.