Total Field 1

[CC801340]

I have a Table called "DaysTimes" which contains the fields "Mon", "Tue", "Wed", "Thur", "Fri". The data type for each field is set to "Yes/No".

I have a report which displays the data and the yes/no values from each record.

At the bottom of the report I would like a "Totals" field to display the total number of "Yes" values for each field. What would be the best way to achieve this? I guess I just need a series of text boxes at the bottom of the report with the control source set to be "SELC COUNT..." but I cannot get the syntax correct!

Many thanks

 

[dhookom]

Try text boxes with control sources of:
=Abs(Sum([Mon]))
=Abs(Sum([Tue]))

Duane
MS Access MVP

 

[CC801340]

Thanks for that - however it just returns "#error" when I view the form.

 

[SuicidED]

=Sum(IIf([Mon]=-1,1,0)) and so on will hopefully work in your report.

 

[dhookom]

"however it just returns "#error" when I view the form"
This is a reports forum. Is this a report or form?

Did you place the text boxes in the Page footer or Report footer. Page footer won't work. Group or Report footers will.

Duane
MS Access MVP

 

[CC801340]

Many thanks for that - I was putting it in the page footer! It works ok in the report footer as you said.