Sub Report from Multiple Reports --- HELP, (please)

[RonnieDobbs]

I was wondering if you can create a subreport that pulls sums from multiple reports. All four reports pull from the same table. Basically I have four reports that query assingment terms, (standard fee, non-standard fee, Off limits,no offlimits, ect....) I have totaled these by office on each report. What i need now is a high level summary total for each office.

Could i do something like this???

=([Textbox_1].[Report1])+([Textbox_4].([Report2])

As you can tell, I am not very good with coding...

Thanks,
AB

 

[hymn]

have a look at
Thread703-916355

Hope this helps
Hymn

 

[RonnieDobbs]

I'll try a different approach...If I create a report say for one office, is there a way to use the count or sum function to list total of records if they meet a certain criteria? I am looking to have four total boxes at the bottom of the report with different criteria.

For instance, query looks like this:

Office Number Fee Expenses

London 1 std Non Std
London 2 Non Std Std
...... 3 std std
...... 4 Non Std Non Std


Total box_1 =SUM IF(fee = std) AND (expenses = non Std)


Total box_2 =SUM IF(fee = STd) AND (expenses = Std)

Thanks for the input...
AB

 

[hymn]

Do you mean something like below

if YourFieldName = Your criteria then
=Abs(Sum([YourFieldName]))
endif


Hope this helps
Hymn

 

[RonnieDobbs]

yes, but with multipe cirteria:


I have this =Sum(IIf([offlimits]="Std",1,0)), which works ok, but now I would like to have another cirteria. I would like the [offlimits] to be "standard" AND the [fee] to be "Non Standard"

I am just having problems with adding the 2nd criteria into the code...

thanks,
AB

 

[hymn]

=Sum(IIf(([offlimits]="std" And [fee]="[non standard]"),1,0))
should do it

Hope this helps
Hymn