Access 2010 Charts

lhtila
lhtila used Ask the Experts™
on
How do I create the next 14 months - Apr 16, May 16, etc . where no data has been captured
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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

Author

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 Liason
Most Valuable Expert 2012

Commented:
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.

Author

Commented:
Thank you for responding so quickly; I have decided to let Access bring in the months as the audits are completed.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
so, ...problem solved?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial