Bean Machine
Member
- Local time
- Today, 00:43
- Joined
- Feb 6, 2020
- Messages
- 98
Hi all! I have two queries, one detailing the sum of revenue over three years and the other detailing the sum of expenses over three years. I want to have a query that shows the two sums beside each other along with the years. The two queries both only have three entries, but when I combine the fields in a new query the results are tripled for whatever reason. I am not sure what is causing this issue but I only want to see the unique values within the combined query. I tried using the "SELECT DISTINCT" expression in the SQL but to no avail. I will include images to hopefully give some more background on what I'm trying to accomplish.