Hello
Can anyone help me with a LINQ query.
I have the following
Dim query From transaction in _SourceDataTable
Group transaction By
account = transaction.item("Account")
Into BuyAmount = Sum(Convert.ToDouble(transaction.item("Buy"))), _
SellAmount = Sum(Convert.ToDouble(transaction.item("Sell)))
Select account, BuyAmount, SellAmount
This works fine to bring me back the total for each account, however, i just want the total BuyAmount and SellAmount for the whole Data Table, however, cant seem to get an Into statement without the Group By.