Search results

Hello, Is it possible to remove rows that has a sum of 0? Table: And my expected result should be: I don't have any idea if this is possible because the subledger is all the same thus I don't know how to use the "group by". Any help would be appreciated. Thanks.

Hello is the SUM query in ms access different in SQL because I've got a SQL query and it is working as intended but when I convert it into ms access it works differently? Here is the syntax: INSERT INTO tblKnockOff ([Object Account], Description, [GL Date], [Document Type], [Document Number]...

Hello, I'm new to ms access and I was wondering how do you insert a new row that has the the sum of a query? The table look's like this: Object Account | Subledger | JE Explanation | Actual Ammount | Remarks Tom*************abc*******Orange********100.00*******Apple...

Hello, I'm very new with MS Access and have a brief background on SQL. I'm having problems with deleting this query: DELETE a FROM Sheet1 a LEFT JOIN Sheet1 AS b ON a.Subledger = b.Subledger AND a.[Object Account] = b.[Object Account] AND a.[Actual Ammount] = -b.[Actual Ammount] WHERE...