right, what I suggested will do that. What’s not working when you try it? In your example if it’s only returning jan and may (the ones with 2 values) it’s because you have an inner join. Make it an outer join.
edit and I see what you mean about the dates.,
Use a case statement in a calculated field.
This is a really bad example, but basically this is the structure. If your first date is null, use the second date, if the second date is null use the third date, else use the first date. Make sense? I can’t remember if it’s going to return empty string or null, so you’ll have to play with that.
Something along the lines of this.
case
when POSugQty.Calc_Date is not '' then POSugQty.Calc_Date
when JobQty.Calc_Date is not '' then JobQty.Calc_Date
else OpenQty.Calc_Date
end