Hey guys
I've been going over the Agg. queries and Agg. functions because I need (want) to put an "At-A-Glance" box in one of my form headers.  It is a "Daily" continuous form displaying Booking Reservations.

For clarification: Each day I have AM/PM bookings.  We can currently book a max of 25 groups at once. Each group can have 1 up to 5 participants in the group. Each group can either be Self-Guided or we can supply a Guide.  Based on the above, I need to break out a bunch of different counts.

I have a several questions.  
Are there advantages or disadvantages over running multiple DLookup, DCounts, DSum vs running an Aggregate Query and putting the results into the header?

While Richard has done several videos on making them I don't recall and or can't find putting the Agg. results on a continuous form. Can that even be done?  (No I have not tried it -- YET)

What are the timing issues I should be aware of in having something like this in the header vs in the footer?

Any advice or guidance you might provide would be greatly appreciated!