I have two tables. Sales and Receipts
Now, I want a report which display for each Customer_ID, sales and receipt transactions grouped by date.
The report would look something like this
Customer ID: 1001
Receipt - 0201 - 1/1/12 - 23,000
Sale - S5444 - 1/1/12 - 10,000
Sale - S5477 - 2/1/12 - 12,000
Sale - S5699 - 3/1/12 - 20,000
Receipt - 0210 - 3/1/12 - 24,000
Like that. The transaction would be grouped according to date. How can I achieve this in Access?