Queries of multiple child records

[Jeff]

I have a report that I'm trying to write. It pulls information from 4
different child records in the database and wants to report them all
in the same report, summed. Many times, there will not be any instance
within the time frame, so it's quite possible to have no data for one
or more of the child records. Right now, I have 4 different queries,
and I was using subreports to include them all on the same report --
until I was told that the results need to be summed.

Is there a good way to combine these into 1 query and sum them?

Thanks

Jeff

 

[Guest]

You might be able to use a union query to combine your queries into a single
record source. It's a bit difficult to make a more specific suggestion
without a better understanding of your queries/tables/data.