NEWBIE question. Fields with calculations correct on form not showingup on report?

  • Thread starter Thread starter p-rat
  • Start date Start date
P

p-rat

I have basic fields that are on a data entry form so when the clerk
types in quantity and unit price the TOTALS field calculates this.

When I look at or pull in the TOTALS field on my report it just shows
$0's. How do I get the report to show what's on my form?
 
I have basic fields that are on a data entry form so when the clerk
types in quantity and unit price the TOTALS field calculates this.

When I look at or pull in the TOTALS field on my report it just shows
$0's. How do I get the report to show what's on my form?
Click to expand...

The TOTALS field does not (or at any rate should not) exist in your table.

Just redo the calculation on the report in the same way that you're doing it
on the form. The Report isn't based on the Form; it's based on the Table, and
should use the data that's in the table.

John W. Vinson [MVP]
 
Back
Top