The operation has to be same and the date a 3 date range
is that bank within +- 3 days of book? or bank is within 3 days after book?
With regards appending to another table, I will leave that to you - it is not clear whether you want the two records side by side or as two separate records. If the latter, you will need two append queries based on the below. Also not clear whether you want to append the individual amounts or just the totals, if the former use the below to identify the operations (i.e. instead of SELECT *, use SELECT B.Operation) and then link back to the individual operations in another query
Assuming +-3 days and totals only, your query will look something like this
Code:
SELECT *
FROM qryBook B INNER JOIN qryBank K ON B.operation=K.Operation AND K.TransDate BETWEEN B.TransDate-3 and B.TransDate+3 AND B.Amount=K.Amount
or viewable in query design
Code:
SELECT *
FROM qryBook B INNER JOIN qryBank K ON B.operation=K.Operation
WHERE K.TransDate BETWEEN B.TransDate-3 and B.TransDate+3 AND B.Amount=K.Amount