Average on Report

D

Dave Elliott

I have a report with a sub-report on it that I need to average the value of
a control on the sub-report
main report is named RReceivables_Date_Report and sub-report is named
Report.FTimeBillingSub
on the sub-report in the footer is a textbox (Text39) with it's control
source set to:
query name is RQInvoice

=IIf(Nz(DSum("BillAmt","TTimeBilling","TimeID=Forms!TimeCards!TimeID"),0)=Nz(DSum("Payment","TPaymentSub","TimeID=Forms!TimeCards!TimeID"),0),0,DateDiff("d",Date(),DMax("BillDate","TTimeBilling","TimeID=Forms!TimeCards!TimeID")))

this gives me the days since the invoice was invoiced
I need to average this and put it on my report.
How, Where can I do this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Difference Help Needed 5
Missing End If in Code ?? Where? 7
If VB Yes, make label visble, How? 2
After converting mdb to mde, code error: See Below 1
want to add sum fields in different sections of a report 1
Open Form Linked to Main Form? 14
Hide Sub-Form, See Module & Code Below 2
Relationship Problem, This is a hard one for me. 0

Top