Text Box, Control Source Help

[Bob V]

On my Report I have a text box that shows the total of Invoice/Payments
=IIf(subChildOwnerInvoiceAmount.Report.HasData,subChildOwnerInvoiceAmount.Report.tbAmount)
What I would like to do is have another text box that will show what
[tbAmount] is showing < 30 days back using the date in [tbInvoiceDate]
Any help would be appreciated............Bob

 

[UpRider]

Bob, if there can be more than one record involved in calculating the
amount, take a look in vba help at the DSum function.
If only one record is involved, DLookup might be faster.

UpRider

 

[Bob V]

Thanks UpRider, but TbAmount is already calculating the total as you enter
Invoices or Payments
tbAmount --> =[tbAmount1]+tbOverDueAmount.Value
Thanks for your help....Bob

Bob, if there can be more than one record involved in calculating the
amount, take a look in vba help at the DSum function.
If only one record is involved, DLookup might be faster.

UpRider

On my Report I have a text box that shows the total of Invoice/Payments
=IIf(subChildOwnerInvoiceAmount.Report.HasData,subChildOwnerInvoiceAmount.Report.tbAmount)
What I would like to do is have another text box that will show what
[tbAmount] is showing < 30 days back using the date in [tbInvoiceDate]
Any help would be appreciated............Bob