Query to reconciled

[GCLIFTON]

Need help to finish writing an query that will per the grouping of [Operation#], then by [GL_Account] in which i have in Operation Qry. All this is doing is pulling out all of the duplicate and telling me what i will be reconciling by Book Amounts


I then need a query that would by the Table or the 2 queries to: per [Operation] then by[ GL_Account]=112265 to take the[ Book] amount and sum or give me the variance of all totals to the[Bank] Amounts having the same date as the [Book] in [GL_Account] 112265 Amount that ties to zero. Even if it is 1 to many that has a variance of Zero or 1 to 1 By the same date of the [Book] Amount. [book]+[Bank]

then the same thing by [GL_Account] 112266 = up to+1 Day of the book to The [Bank] Amount: Ex Book 100.00 on 9/1/2016 [Bank] should have amount the on 9/2/2016

Then

Same as above but slightly changing


Combining the [2 GL_Account] Together and run the same logic but have it cross GL for = up to +2 Days of the book Data

Then the last thing

If after running the above and it does not tie to zero or their is difference. Take that difference amount and run the above until nothing ties to zero and go to the next [Operation]