Calculating a % of yes/no answers within one report

[SteveCampion]

I'm a Access novice trying to set up a table to record the answers to simple yes/no questions. I've got all the questions set up and yes/no fields set for their responses, but I now want to add a field that calculates the percentage of yes responses on that particular report and record that too.

Is this possible? I'm trying to use the 'calculated' data type, but then I can't work out what to type as the expression. I may be going about this totally the wrong way and any direction would be much appreciated.

Cheers.

 

[Brianwarnock]

Don't store the total in the table, calculated fields stored in tables can lead to problems and tables are for storing data not for looking at it, that is done in forms and reports based on queries in which you can do the calculation.

Countofyes: sum(iif(checkfield,1,0))

Countofno: sum(iif(checkfield,0,1))

The = TRUE is the default and thus omitted , TRUE is the same as Yes

Brian

 

[SteveCampion]

Cheers, I thought that could be the case!

As I said, very much a novice, but at least the table and form are done!! I'll tackle the queries next and then hopefully I'll come accross where to feed that in!

Thanks again.