I have a database, I have a report in there that is separated by quarters, and years. 1,2,3,4 quarter. The data shows up once it has been put in the database. If there was no information for that quarter then no record will show at all. I am wanting, if there is no record (I want it to throw a zero in all the spots) Not just skip it, and wait till the next incident. Now if there is an incident it will put a value in one of the tables and show up correctly, if not then it want show up, cause there is no record, and no need to have a record if there is no incident. I just need it to throw zero's if there was nothing for that quarter.
Can you help me out here?
Thanks