SELECT stmt for footers

[TammyT]

I have a report that has 2 footers for the same "field" (Agency). I want a separate footer for each, because I need to add logos/other agency-specific, non-Db info for each of them.

I have a "main" query that is pulling the data records, & I have all of my formulas in place for the appropriate calculations.

I need (I think!) something for the On Format property of each footer to tell it that, for footer 1 I want to select only those records from the query where the agency = AgencyName

I know you can do SELECT statements in the VBA, but I can't seem to find the format.

Am I on the right track, or is there a better way to do this?

Thanks!

 

[traingamer]

If you 'group by' agency, you will get a group footer to work with.
How do you plan to include non-db info?

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[TammyT]

I've tried that, & for some reason all I ever get is grand totals! So I'm trying "option 2" - separate footers for each agency. Unless you can solve my footer problem!

I'm putting in the agency logo for each. But, if we can resolve the "math" in the Agency footers, I can leave out the logos.

Thanks!

(I can get grand totals, just not by Agency totals)