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...
 

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

Add to text box String 4
Report Group Count Woes 6
Check Box to control Text Box 4
PLS HAVE PROBLEM IN A FORMULA 3
formula for a nested subform into other form 2
Getting an Error when there is nothing to show 7
Report Text Box question 3
Intellisoft Problem! 8

Back
Top