Search results

Thanks Estuardo. I do want to sum the expense amount, i.e. below. This runs fine and gives me the result I want SELECT Month&"-"&Year AS Concat, SUM ([Expense Amount]) AS Total FROM New_Raw_Data GROUP BY Month&"-"&Year Then when I change it to this it doesnt SELECT Month&"-"&Year AS Concat...

Can someone please tell me whats wrong with the following code SELECT Month &"-"& Year AS Concat FROM New_Raw_Data GROUP BY Concat I keep getting the error "you treid to execute a query that does not include the speficied expression.......... Thanks!