Forum Discussion
Group by Quarter
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" s...
You are using different datatypes for Amount in each table. Currency & Number. Be consistent.
The union query only works because Currency is a special type of number.
UNION ALL will return all records including any duplicates but UNION will only return unique records.
However both sets of data should be in one table as they have the same structure.
Merge the data then the grouping will be fairly straightforward.
