Back 1Month query Result!

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

Bob V

Is it possible to make this field go back 1 Month to get the payable total?
This field is giving me the payable total of each client
...............Thanks for any help.....Bob
Payable:
Nz(qTotalDueForPayment.TotalDue,0)-Nz(qPaidAmountForPayment.PaidTotal,0)
 
It depends. Can you get qTotalDueForPayment.TotalDue AND
qPaidAmountForPayment.PaidTotal to "go back one month"?
If those queries are run with date parameters, rather than all payments to
date, then the answer is Yes. Otherwise, probably not.

HTH,
 
Back
Top