I have master list of customers. I then have a table that is linked to this table by a key field with a Fiscal Quarter and a Sales field.
The problem is, that the second table doesn't have a value for the Sales for each Quarter, for each customer. I need Sales to have a value and not be null in this table for each Quarter, but I'm not sure how to accomplish this.
So say I have 100 customers. Then I have 4 Quarters for the year.
I should have 400 records. Each customer should have a value, to show for each Quarter, for the Sales, even if that value is 0.
1 (instead of null)
0 (instead of null)
I have tried just creating a table with the master list and having a 0 for the Sales field and then Concatenating that to the second table but I don't think that is giving me the results I want.