Hi
In Access 2003 using a query to group by and sum on 2 fields [BUY SIDE QUANTITY] , and a seperate field to sum on [SELL SIDE QUANTITY]
Am importing data from 2 sources and trying to sum within access
I have the following: see attached
The Fileds are data type "Long Integer" in the table
I should get one line in the output
I'm getting two lines...
I'm confused...
In Access 2003 using a query to group by and sum on 2 fields [BUY SIDE QUANTITY] , and a seperate field to sum on [SELL SIDE QUANTITY]
Am importing data from 2 sources and trying to sum within access
I have the following: see attached
The Fileds are data type "Long Integer" in the table
I should get one line in the output
I'm getting two lines...

I'm confused...