Hey does anyone have a clear answer to this, I can't include aggregate functions within a combined query, this is what I am doing, <cfif form.glimpseFormat eq "1"> <cfif form.criteria eq "1"> SELECT max(averFlow) as maxaverFlow, (SELECT datePart(dd, dt)) AS day FROM dbo.milford WHERE datediff(day, dt, getdate()) = 0 <cfelseif ..... <cfelse>.... is it possible to combined aggregate functions? this is my error Column 'dbo.milford.dt' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause Thanx in advance... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists