Access Report 1

[takeover]

Hi,

I have a students report which has these fields.

Subject StudentID Name DateAttended

I am grouping the report by Subject on the report level and calculating the sub total of DateAttended by having a count field. My problem is I cannot find the average in this report. The average should be The total days divided by number of students. When I do the average whicg the report provides, it is calculated like this, total days divided by the total number of records. Is there any way I could achieve it?

takeover.

 

[PaulBricker]

Here's what you do. Add another Group Level Header for Students. Add a textbox to that Group Level Header(I'll call txtRunningSum). Set the Control Source to =1 and set the Running Sum property to Over Group. Set the Visible Property for the Group Level Header to No. Then put this expression in your Subject Group Footer

=txtRunningSum/Count(*)

That should give you the values you need. Then you can format the answer however you need.


Paul

 

[takeover]

Hi Paul,

That was a gem. It is workinga nd a BIG thanks!!

takeover