Hello,
I have a continuous form that has a textbox named InvoiceAmount. This
textbox is not a calculated field. It's control souce is a field also
named InvoiceAmount in the tblInvoices table. In the form footer, I
have a textbox name txtBatchTotal which should show the sum of all
invoices in the batch. The control source of txtBatchTotal is
=Sum([InvoiceAmount])
This gives me a #Error in the txtBatchTotal field.
I should mention that I'm using Access 2002 ADP with SQL 2000. Please
let me know if you have any suggestions.
Thanks.
Julie Vazquez