I found an interesting situation.



I have 2 queries that use different tables with information about a series of horse races. In one case the query is looking at the horses that finished 1st through 3rd and in the other case it is looking at the horses that were 1st through 3rd in the early part of the race. They can be the same horses, different horses, partially the same and partially different horses for each race.

In each case, it is looking at a handful of fields, doing a calculation, and creating an output field (one query is producing out1 and the other out2).

I am then taking the output of those 2 queries, joining and grouping them on Date and Race and trying to create a single record with Date, Race, the AVG of out1 and the Sum of out2.

I can see the potential issues with that because not all the records contain both out1 and out2 values, but it seems to be working fine for AVG and giving me bad values for the SUM.

I hope that is clear, but if not I'll try again.

Thanks