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

[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?

 

[John W. Vinson]

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?

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]