Calculations on forms to be shown in reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi!
I have 3 fields on my form which contain expressions/calculations.

These fields are:

GermanCourseworkMark

GermanExaminationMarkF

GermanExaminationMarkH

The value of the calculation is shown in these fields on each records,
however when I go to the reports, the value of these fields on every record
is shown as 0.

Any ideas of how to solve this problem please?

Thank you in advance!

Emma
 
Emma,
Let me see if I understand, The 3 textboxes (Forms and Reports do not have
fields, tables have fields) on your form are calculated based on fields in
your table, but are not carried in the table. I am also assuming that the
report has the same table or a query based on that table as it's record
source, so that the report has no knowledge of the calculated text boxes on
the form. If my assumptions are correct, then what you will need to do is
put the same calculations in the text boxes on the report as you use in your
form.

If I have misunderstood, then let me know and we can find another approach.
 
Back
Top