Dear buddy access programmers,
I have a database consisting of 2 tables:
Table A: Sales
Table B: Returns
I am trying to create a query that has the following fields:
Date
Transaction type (sales/return)
Quantity
Can you guys help me out?
Again, my main question is how do I put the sales and returns under each other according to the date.
[Note: I am not a beginner so please don't try explaining the basics of creating a query.]
Thank you in advance.
James Borne