Jun 19 2022 06:30 PM
Hello Experts,
I have 2 tables in the attached that I am having difficulty grouping by quarter based on the date but then also by the field [Group].
The field [Group] is either "P" or "T"
so the output would need to include:
My goal is to compare the sum of amounts for each quarter of the year by [CoName] and by [Group].
I have tried to make a Union ALL but i had duplicate values.
I also tried to combine the tables on [CoName] but also had duplicates. My approach might not be correct. Looking for some guidance. Grateful for the help.
Example Output.
This is only to provide a visual. I am open.
Let me know if any questions.
Please see attached with 2 tables.
Jun 20 2022 12:25 AM
Jun 20 2022 05:32 AM
Solutioni made small queries, but the final is qryFinal.
Jun 20 2022 06:57 AM
Jun 20 2022 07:40 AM - edited Jun 20 2022 07:40 AM
Please take into consideration the potential difference between a solution and a work around.
It reflects the difference between long-term and short-term thinking in a lot of ways.
Jun 20 2022 05:32 AM
Solution