|
|
|
новичок
      
участник
Last Login: 25.01.2002 20:54
Сообщ.: 2,
Visits: 23
|
|
Y menya est table s colonkami: amount and name. Mne nyshno podschitat dlya kashdogo name sum(amount). Kak mne eto sdelat v Access?
|
|
|
|
|
Supreme Being
      
участник
Last Login: 07.03.2005 18:49
Сообщ.: 365,
Visits: 4 016
|
|
| SELECT name, Sum(amount) AS SumAmount FROM Table1 GROUP BY name;
|
|
|
|