Urgent query needed

[lee]

event mode max_wgt
pi t 2000
ppi l 300000
pddi t 23000
pd t 12000
ippd l 50000


i want to calculate total of max wgt for every event and mode
combination. Event column would have only 2 values either that ends
with i or that ends with d . so i want a sql query in access which
will give the output

as the following table

event mode totalof max wgt
i t
i l
d l
d t


can you pls suggest

 

[John W. Vinson]

event mode max_wgt
pi t 2000
ppi l 300000
pddi t 23000
pd t 12000
ippd l 50000


i want to calculate total of max wgt for every event and mode
combination. Event column would have only 2 values either that ends
with i or that ends with d . so i want a sql query in access which
will give the output

as the following table

event mode totalof max wgt
i t
i l
d l
d t


can you pls suggest

SELECT Right([Event], 1) AS EventType, Mode, Sum(Max_Wgt)
FROM yourtable
GROUP BY Right([Event], 1), Mode;
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[lee]

event  mode  max_wgt
pi         t         2000
ppi        l        300000
pddi      t         23000
pd         t       12000
ippd      l        50000

i want to calculate    total of max wgt for every event and mode
combination. Event column would have only 2 values either that ends
with i or that ends with d . so i want a sql query in access which
will give the output

as the following table

event  mode   totalof max wgt
i           t
i           l
d           l
d          t

can you pls suggest

SELECT Right([Event], 1) AS EventType, Mode, Sum(Max_Wgt)
FROM yourtable
GROUP BY Right([Event], 1), Mode;
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com

thanks John. appreciate it. much.