F
Fay
I am generating Invoices for Clients (as a report) that only itemize Services
and Payments which have occurred since the date of the prior invoice. I need
to replace the LastInvoiceDate and the Balance in my BalanceForward table in
order to do this. However, I have been unable to generate an Update Query
using the BalanceForward table plus a query, NewBalance, that determines
which Client accounts to update and what the new balance is. I understand
that if you calculate a field within a query, you won't be able to update it,
but this calculation is already incorporated in the NewBalance query. Can
someone help, please?
Thx.
and Payments which have occurred since the date of the prior invoice. I need
to replace the LastInvoiceDate and the Balance in my BalanceForward table in
order to do this. However, I have been unable to generate an Update Query
using the BalanceForward table plus a query, NewBalance, that determines
which Client accounts to update and what the new balance is. I understand
that if you calculate a field within a query, you won't be able to update it,
but this calculation is already incorporated in the NewBalance query. Can
someone help, please?
Thx.