Forms: Unbound field totals in reports

[Guest]

I don't know whether this is the best place to post this or reports, because
i don't know where i would solve this problem on my system.

I have a 3 fields 'GermanCourseworkMark', 'GermanExaminationMarkF' and
'GermanExaminationMarkH'. these field all each contain an
expression/calculation.

On my reports the values in these fields are shown as zero, although there
are numbers in these fields in the forms. I need numbers to be shown in this
fields on the reports

Please help.
Thank You

Emma

 

[Wayne Morgan]

The confusion is coming from the fact that these aren't fields (part of a
record source), they are controls (items on a form). You have calculated
controls on the form, they are taking data from elsewhere, probably fields
in the form's record source, and giving a calculated result. You will need
to create calculated textboxes in the report also. Once you do this, the
report will also calculate the values you want.

It is possible that the calculations are being done in the query feeding the
form, but if that's the case, then using the same query for the report's
record source should have the calculations available for the report also.
So, I suspect that the calculations are being done in the form itself,
either with calculated controls or VBA code behind the form. Open the form
in design view and take a look are the Control Source for the controls that
show the result of a calculation. Is the Control Source an equation?