Calculating Reports text fields

message from =?Utf-8?B?SmFzb24=?= on 10 May 2004
I'm having difficulties doing something that should be simple, and it may be I just am missing something. Any help would be appreciated.

I have a report with various subreports on it, all with different queries as the control source. In the main report I would like to calculate the totals stored in a text box for each of the subreports.

I can do this fine unless one of the subreports does not show because the parameters for the query return no results for that particular query.
 
Pieter Wijnen replied to =?Utf-8?B?SmFzb24=?= on 11 May 2004
that way you can trap (avoid) the errors

HTH

Pieter

"Jason" <anonymous@discussions.microsoft.com> wrote in message
news:DF495227-A3DB-4756-90CC-4EE17607F473@microsoft.com...
be I just am missing something. Any help would be appreciated.
as the control source. In the main report I would like to calculate the
totals stored in a text box for each of the subreports.
parameters for the query return no results for that particular query.
 

Archived message: Calculating Reports text fields (Microsoft Access)