Replies

I ran reports in early January, using December dates. I had no problem then. The db is not split.
I can run a report with dates between 1/1/2002 and 1/16/2002. Any query that goes past the 16th will run as a query, but not as a report. I’m totally lost!

Thnaks for the suggestion. Just to make sure, I went back to all date fields and changed them to YYYY. Since we all are using Win’98 I did not think this would make a difference, and it didn’t. Even with all dates having 4 digit years, and all filters using 4 digit years, I still can’t run these.
I’ve run them monthly without problem up until now. The last run was in January, using dates through December 2001. This is the first run using dates in 2002. Is there anything unique about 2002?

You are incredible! I’m really trying to make a dashboard for the executives, the kind that has 10-12 specific
numeric targets and the associated ongoing (quarterly) data that tells them without looking whether we are
exceeding or way behind target. So most of them will be simple line graphs with the data points changing
color. I think we’d be better off not trying to change the lines since there is always one more data point than
line, and they would invariably argue whether it should be the line before, or after, the data point.

How/ where did you learn this? I’m just a simple Excel user struggling now with the conversion issues of ’97 to
2000. I have heard that Excel can create reports basically equal to what Access can do, and can hold macros
and formulas which do all that I want. But I’m not a programmer, and have struggled to learn the simple SQL
formulas needed to make Access useful.
Judy

Grame,
hanks so much. Control charts definitely are part of what I want. I’ll play with this.
Sam, the next responder, attached an excel file which goes about it a different way. You might be interested in that also.
Judy

Sammy,
Thanks a bunch! I see the colored bars, now I need to look at the macro and make sense of it. I’ll also play with it to see if data points can also be changed this way.
Much appreciated- I wish I had your knowledge. Thank heavens for this forum.
Judy