Attached are the 2 queries in 1 union Query having an extra column label saying Book and Bank see attachment I have also had this union query sent to a Table name: Combine_tbl
I would like (for example) to take all the one for one data that automatically nets to zero for all, but for this example, 1840 that is highlighted, to be removed out of this table to a [NET_TO_ZERO] table or query so can i create a report showing all that nets to zero 1 to 1. This output should look exactly like the combine_tbl format but only showing all that nets to zero 1 to 1
NEXT
once the above data has been pull out, the 80.00 and 2 (-40.00) should be the only things left. They should go to another query or table that is call [Outstanding] I will then take the [outstanding] query or table and run the logic for a 1 to many and combine all that nets to zero from that run to the same tbl or qry [NET to Zero]. If there is anything still left it shoudl stay in the outstanding Tbl or qry
Same logic: if operation are the same, for each book item, find one to one offset within +5 data range of the book data---- Then after 1 to 1 are found and moved: if operation are the same, for each book item find one to many offset within +5 data range of the book data and move.