Grouping field with same item

**okl** · 02-20-2010, 03:30 AM

Hi,

I trying to Group field1 with same item. But i cant get "T" group as 1 item.
Return me 2 "T"s

Code:

SELECT Table1.Field1, Table1.Field2
FROM Table1
GROUP BY Table1.Field1, Table1.Field2;

Query Result:

HTML Code:

Field1	Field2
K	2
P	1
T	1
T	3

**DonkeyOte** · 02-20-2010, 03:57 AM

In your query you're grouping by both Field1 & Field2 so the query will return all unique combinations of both fields (eg T:1, T:3)

Assuming you're looking to Sum Field2 by Field1 (ie a SUMIF) then:

Code:

SELECT Table1.Field1, SUM(Table1.Field2)
FROM Table1
GROUP BY Table1.Field1

**okl** · 02-20-2010, 04:07 AM

Thanks!

Thread: Grouping field with same item

Thread Tools

Rate This Thread

Display

Grouping field with same item

Re: Grouping field with same item

Re: Grouping field with same item

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions