Back 1Month query Result!

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)
 
G

George Nicholson

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,
 
Top