Dsum in report section footers

[dbase3man]

I have a linked table of payments received called Pay_verify1 where payments are recorded in batches daily in which the batch number is system generated. Each batch contains several revenue codes. I have a report with batch number as section header and I would like to get subtotals by batch number, and by revenue codes, in the batch number footer in an unbound text box control.

=DSum(“[Amount]”,”Pay_verify1”,”[Revcode]=’7487’) works fine in the report footer but not in the batch number footer.

When I try =DSum(“[Amount]”,”Pay_verify1”.”[Batch_no]= & Batch_No) AND [Revcode]=’7487’) in the batch section footer, I get #error. I piece this together from reading examples from online forums. Any help will be appreciated thanks.

 

[SkipVought]

Hi,

What Application? If you are in MS Access, I suggest posting in Forum703, or one of the many other MS Access Forums.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}