Text Box, Control Source Help

  • Thread starter Thread starter Bob V
  • Start date Start date
B

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

UpRider said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top