Text Box, Control Source Help

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
 
U

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
 
B

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

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

Date Range Report 0
MS Word normal.dot cannot be fixed 'text box' appears each time 4
Add to text box String 4
Contents of a text box 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Style Header Reformatted 3
PLS HAVE PROBLEM IN A FORMULA 3
formula for a nested subform into other form 2

Top