Search results

Im so sorry I know now what you mean and it's a mistake on my part so stressed with this.. Basically there's a condition and that is the sum of duplicate recrods of ColumnA and ColumnB that the sum is 0. Basically: ColumnA, ColumnB, Amount 123, 555, 10 234...

It just need to return data that the sum is equals to 0..

First of all I want to thank you for your response, I greatly appreciate it. Any that has value that when sumed the answer is 0 but the query should be 1 to many or many to 1 Like: Subledger, ActualAmount AAA, -1 AAA, -2 AAA, 3 Or Subledger, ActualAmount AAA, -1 AAA, -4 AAA, 5 Or...

Yes but as long as the sum value is 0 it is okay. So basically it can remove anything.

Ooops sorry it should be: Subledger, ActualAmount AAA, -1 AAA, -2 AAA, -4 AAA, 7

From your example we can remove the sum of the negative w/c is -7 and 7.

Sorry for the lack of data, basically the table is like this: From the table the those in subledger that is WWE12 and AAA333 has a sum of 0 when added together. But in WWE12 it has 5 data where in it is -217, -43, -260, and 48994. If you add -217, -43, -260 it has an equal value of 0. And the...

Well the expected result should be the result image but the problem is when I do the query the output is that it selects all of the values just like in the table image.

Well the values here in the result image are equal to 0 if u sum it, thus the -25755 and 48994 should not be in the result. Basically I'm looking for values that has a sum equal to 0

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.

Thanks for the response and I think I know the problem now, its because some of the data in other columns are different.

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]...

Thanks a lot its done now :)

Update on this I made a SQL version on this now I'm having trouble on converting it from SQL to MS Access, Any help on this? Here are the actual fields for this data, any ideas how to convert this?

I'm just using a test table for it and I attached it here just in case :) thanks in advance :D

Can you tell me how can I achieve that? I don't have any idea on how to achieve it with a sub query of duplicates of subledger, account and explanation

oops sorry the expected result should be Tom**********abc********Apple********500.00******* Apple thanks for pointing it out.

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...

Well I have 2 tables in that database and the 2 tables are named Sheet1 and Sheet2. I have a query that transfers duplicates that has the same subledger, object account and actual ammount from Sheet1 to Sheet2 and delete it afterwards. The insert is working perfectly and my problem is with the...

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...