Hello,
I know this is a very low level question, but google isn't working for me
I have two subqueries that I want to link. One query calculates a person's cost and another query returns his income.
The query I'm making should display for each person that is in the first query OR the second query, his cost & income.
So let's say we have 3 people.
person A is in both queries, then in the third query he will have a value for cost & income.
Person B is only in the cost query, then in the third query he will have a value for cost, but a blank or a zero in the second colum.
Person C is only in the income query, he will have a zero or a blank in the cost column.
Currently, my query only returns person A. Should I perhaps first make a union query to group all possible combinations, and then link to costs & income?
Thanks for your input!