Thank you guys. It's looking like I may have to go the insert route. I tried the LEFT JOIN and for some reason, the output did not produce records with other null values. I figured I would try a CROSS JOIN, outlined in this recommendation:
Unfortunately, I need to perform aggregate functions on the entries in my report. For example: SUM(Amount). I am not sure if that, by doing a cross join and producing duplicate amount records, it may interfere with the calculations. I will have to try it out and see. If this does not work, I have no choice than to add the artificial records. Either way it goes, it's going to be a long night! Thanks again