Access 2010 Charts

How do I create the next 14 months - Apr 16, May 16, etc . where no data has been captured
lhtilaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

FlysterCommented:
If you're working off a table, just enter each date with a null value (4/1/16, 5/1/15, etc.) The chart should show those dates with no data.

Flyster

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
lhtilaAuthor Commented:
Thank you, I have a query that contains parts of the main table, expression. I created a make table and the months pulled into the chart. Will data captured in Dec pull into the chart?
Jeffrey CoachmanMIS LiasonCommented:
I have a query that contains parts of the main table, expression. I created a make table and the months pulled into the chart. Will data captured in Dec pull into the chart?
This is a bit confusing, ...
A sample database would be helpful here.
As it is not entirely clear what your data looks like, ...nor what you need the final chart to look like.
lhtilaAuthor Commented:
Thank you for responding so quickly; I have decided to let Access bring in the months as the audits are completed.
Jeffrey CoachmanMIS LiasonCommented:
so, ...problem solved?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.