Using Data from multiple queries in Report Footers

[John]

Is there any way to put some totals from multiple queries
in the report footer.

Every time I try to do it I get a parameter asking for
data.

 

[john]

I don't really want to use subreports. I just want it to
count one field from a query and sum another. Thx

 

[Duane Hookom]

You can use Dlookup() or DSum() in the control source of a text box.

 

[Guest]

I've tried DCount () and DSum () and I keep getting a
message box to input parameter values.

If I want to just count the total number of records from
a query called ScheduledBriefings from the field
Briefings with no criteria, how would it look?

Thx

 

[Duane Hookom]

I don't understand what you mean by "from the field Briefings with no
criteria". You can try:
=DCount("*","ScheduledBriefings")