Summing uncontrolled fields

[ghard123]

At work I am required to keep a daily shift report which is on a form 'Shift Report'. Each day is one record, and from each day various statistics are recorded in unbound fields on each record.

At the end of the month I am required to produce a report with the totals of these unbound fields. Can anyone explain how this is done please?

 

[Galaxiom]

What you call "unbound fields" are actually unbound controls. Controls cannot be summed across records. Only fields in the Recordset can be summed.

These fields need to be in the RecordSource query so your first step is to generate the calculations in a query. Then you can Sum them in the report.

 

[ghard123]

Sorry for late reply and thanks for this information. I will give this a shot.