Date Query 1

[Beowulf005]

Having some issues getting this to work.

Table
Column --Type
Column --Ticket
Column --Value

Trying to create a query that will take duplicate tickets merge them into one row while adding the value.
IE
Type Ticket Value
A 100 3
A 100 2
A 200 6

Results
Type Ticket Value
A 100 5
A 200 6

Thanks for you help

When frustrated remember, in the computer world there is almost always a backdoor.

 

[PHV]

SELECT Type, Ticket, SUM(Value) AS SumOfValue
FROM yourTable
GROUP BY Type, Ticket

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886