By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,488 Members | 1,832 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,488 IT Pros & Developers. It's quick & easy.

MS Access: Code throw a Zero when there is No record for that month

anoble1
100+
P: 230
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
May 18 '09 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,709
I can understand the problem at a conceptual level, but your explanation gives me scant clues as to what you're working with.

I guess I'm saying if you can post a question that's properly explained then I can help with an answer.

In case you can understand at a conceptual level :
You need to provide a list of the dates you want shown and make a query where this data source is LEFT JOINed to your data. That way there will be a record for each date.
May 18 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.