I have a query that is supposed to sum values, but when it gets a negative value it lists it separately instead of adding or subtracting with the rest of the fields values.
Here is the code. I have never seen it do this before. Also this is Access 2007
SELECT [Negative Carryover].[Employee Number], [Negative Carryover].Name, Sum([Negative Carryover].[Allocated Bonus]) AS [SumOfAllocated Bonus]
FROM [Negative Carryover] LEFT JOIN lastmonthsnegative ON [Negative Carryover].[Employee Number] = lastmonthsnegative.[Employee Number]
GROUP BY [Negative Carryover].[Employee Number], [Negative Carryover].Name;
Thanks in advance for any help
Micki
Here is the code. I have never seen it do this before. Also this is Access 2007
SELECT [Negative Carryover].[Employee Number], [Negative Carryover].Name, Sum([Negative Carryover].[Allocated Bonus]) AS [SumOfAllocated Bonus]
FROM [Negative Carryover] LEFT JOIN lastmonthsnegative ON [Negative Carryover].[Employee Number] = lastmonthsnegative.[Employee Number]
GROUP BY [Negative Carryover].[Employee Number], [Negative Carryover].Name;
Thanks in advance for any help
Micki