Hi
Though I'm using Access for last 10 years, I don't know to write complex queries. I can't understand inner join, outer join, left join or right join. Is there any help available with examples?
Please help me how to write a query required for me in Access 2007.
Tables
- Master (ID, Name, OpeningBalance fields are required in this table)
- Collection ((I) Sum of Amount Collected (field only) for a period ex. 01/04/2017 to 31/03/2018, grouped by ID and (II) sum of amount collected (field only) for the period before {01/04/2017} grouped by Member ID
- Refunds ((I) Sum of Amount refunded (field only) for a period ex. 01/04/2017 to 31/03/2018, grouped by ID and (II) sum of amount refunded (field only) for the period before {01/04/2017} grouped by Member ID
I want to query (generation a recordset itself is sufficient to create a report) by combing the above data from 3 tables (viz) ID, Name, OpenBalance field from Table 1, Sum(AmountCollected)-1 and sum(amountCollected)-2 from Table 2 and sum(AmountRefunded) from table 3 by matching respective ID (A unique data).
Thanks in Advance