I am using multiple queries in my report and then joining these queries. One part of the join is not working where I am trying to do this:
The individual query calculates the opentime for each record and also the average.
The results are something like this in the 4 columns
open,opentime,name,average
2 0.49444444 XXX 6.36485164
1 13.34444444 YYY 6.36485164
1 0.39930556 ZZZ 6.36485164
1 0.3375 AAA 6.36485164
Now when I am joining this to another query I am losing these values
This is what I am getting when I join the query with another query.
XXX 1 1 6.36485164
YYY 2 1 6.36485164
that is - the column opentime is losing the values and only displaying the averages, wherasI need the individual values as in the first query. Why are the values showing only averages when I join the query? I couldnt figure this out on my own. Any help will be greatly appreciated,
thanks in advance