Calculation in Query

[Doug_C]

Hello,

I a form with the following field:

Report Date, Loans on Report, Renewal Loans and Total.
I have the Loans on Report and Renewal Loans Adding to calculate the Total
Field. as such: =[LnsRpt]-[RenewLns] in the Control Source and works fine on
the form.

In a Subform I have:

Date Worked, Type1, Type2, Type3 and Completed.
I have the Type1, Type2 and Type3 adding to calculate the Completed field.
As such: =[Type1]+[Type2]+[Type3] in the Control source and works fine on the
form.

However, when I run a query with the Date Worked, Report Date, Completed and
Total fields, Completed and Total have Zeros. They do not calculate. I need
to place these fields on a report to show the totals for each day but, also
have them show a grand total for Total - Completed.

Any help would be greatly appreciate and please simplify answer as I am
obviously not too sharp on this sort of thing.

Thanks!!!

 

[Barry Gilbert]

You can do this with controls in your report. You can create textboxes on the
report with the same controlsource formulas as in your form's textboxes.

Barry