Add more stuff to the GROUP BY

1,095 registered users | 0 active users | 2 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #236,025 by ben_tilly 11/25/05 6:30:54 PM Reply	Add more stuff to the GROUP BY All fields that appear in the SELECT must either be aggregate functions (count, sum, etc) or must appear in the GROUP BY. You're missing zip2city.USPSCityName, zip2city.AcceptableCityName, 4_CDS_DelPntRec_AddrType.TypeDesc, 4_CDS_DelPntRec.DelTypeCode, 4_CDS_DelPntRec_DelTypeCode.ResOrBus, 4_CDS_DelPntRec_DelTypeCode.GenYstNst, 4_CDS_DelPntRec.AddrVac90Plus, 4_CDS_DelPntRec.DelPntDrop, 4_CDS_DelPntRec_DelPntDrop.CMRA_Drop_NotDrop, 4_CDS_DelPntRec.DelPntBusFamServicedCount, 4_CDS_DelPntRec.Seasonal, and 4_CDS_DelPntRec_Seasonal.Yes_Not_Edu. Cheers, Ben I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless. -- Aaron Ward (my brother)
Post #236,026 by broomberg 11/25/05 6:31:53 PM Reply	Beat ya
Post #236,027 by ben_tilly 11/25/05 6:33:00 PM Reply	Yeah, yeah. I gave a longer answer. I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless. -- Aaron Ward (my brother)
Post #236,033 by broomberg 11/25/05 6:48:53 PM Reply	I gave less on purpose. Made him think about it, which in turn means he'll learn it better. hehe.
Post #236,040 by ben_tilly 11/25/05 9:03:32 PM Reply	I just wanted to drive home... how much Access had to complain about. :-) Cheers, Ben I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless. -- Aaron Ward (my brother)
Post #236,047 by broomberg 11/25/05 11:04:31 PM Reply	What? Everything after the counts are illegal isn't enough? How can there be more than Everything?
Post #236,064 by ben_tilly 11/26/05 2:18:45 AM Reply	Logic is distinct from visual impact. I was going for that. I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless. -- Aaron Ward (my brother)
Post #236,075 by broomberg 11/26/05 11:37:08 AM Reply	Oh. You were padding. Got it.

Why in the heck doesn't this work? - (folkert) - (10) - Nov. 26, 2005, 12:20:59 PM EST

Here's something I do when working with Excess - (jb4) - Nov. 25, 2005, 06:25:36 PM EST

Everything after the counts are illegal. - (broomberg) - Nov. 25, 2005, 06:29:59 PM EST

Add more stuff to the GROUP BY - (ben_tilly) - (7) - Nov. 25, 2005, 06:30:54 PM EST

Beat ya -NT - (broomberg) - (6) - Nov. 25, 2005, 06:31:53 PM EST

Yeah, yeah. I gave a longer answer. -NT - (ben_tilly) - (5) - Nov. 25, 2005, 06:33:00 PM EST

I gave less on purpose. - (broomberg) - (4) - Nov. 25, 2005, 06:48:53 PM EST

I just wanted to drive home... - (ben_tilly) - (3) - Nov. 25, 2005, 09:03:32 PM EST

What? - (broomberg) - (2) - Nov. 25, 2005, 11:04:31 PM EST

Logic is distinct from visual impact. I was going for that. -NT - (ben_tilly) - (1) - Nov. 26, 2005, 02:18:45 AM EST

Oh. You were padding. Got it. -NT - (broomberg) - Nov. 26, 2005, 11:37:08 AM EST

iwethey.org

Yes, no, maybe so.
126 ms