>can you provide a couple rows of data with no functions? just the ad.acd and >the da.connects? >and what you would like for it to show? whenever you use an aggregate >function like avg you have to use group by >like > >select studentId, avg(grade) >from grades >group by studentId >
Yes sorry I misread your post. The app calls for total calls (which I just provide the data with no funtions) but it also requires an AVERAGE of total calls. Total calls = acd + connects ACD could be multiple records which is why I have to sum first then AVG. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342907 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
