James
Have you tried using Nz() in the queries to force a value if null?
MyData: Nz([MyField],0)
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
--- In MS_Access_Professionals@yahoogroups.com, James McAlister <forums01@...> wrote:
>
> In Access 2010 I have a trend chart plotting percentage (y-axis) versus
> days (x-axis). This all works well except there are a couple of days where
> there is no data, and there's a break in the trend line. This happens
> because I have my queries set up so as to show all days on the x-axis, even
> when there's no data, and that's the way I'd like to keep it. In Excel
> there are chart options (such as interpolate) to automatically deal with
> missing data points, but I don't see such in Access.
>
> I'm on a very tight time constraint and am about to add a table to put in
> two days of "fake" interpolated data for this one final chart run before
> the election tomorrow. That will be OK with the client, but I may need to
> investigate a more proper approach later.
>
> So here's my real question now: is there a chart option that I'm just
> overlooking to deal with missing data automatically? And if so, where is it?
>
> Thanks!!
>
> James
> www.james-mc.com
> Words To Live By
>
>
> [Non-text portions of this message have been removed]
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar