Constructive advise would be appreciated for my question . I have created 3 queries . Query 1: counts Source = Product Transfer yearly. Query 2: counts Source "Not Product Transfer" yearly. Query 3 is the combined result of query 1 and 2 . Is there a more efficient way to produce the results in query 3 ? I have looked at Cross tab query , however my experience with them is limited .
I have attached a demo of what I am attempting to achieve .
Regards Ypma
I have attached a demo of what I am attempting to achieve .
Regards Ypma