Is There Anyway To Force Access 2000 to NOT skip null Row Values In A Crosstab Query

[mcl]

OK I need to explain this. If anyone has followed any of my prev questions
I'm a meteorologist/climatologist. I've used Access quite successfully to
analyse weather data records for stations. If a station takes an ob once an
hour for 30 years thats over 262,000 total records. Even if an observer were
99.99% (unlikely) accurate there are still a number of "fat finger" mistakes
in the records. One thing I've done is create a crosstab query of
temperature counts by temperature and month. For example (I don't know how
well it will line up in the actual post)
Jan Feb Mar Apr May Jun July.............Dec Annual
110 1
99 3
98 1 5
97 2 5 10
etc

The one case of 110 for this stations max temp in July is obviously out of
wack. The acual max was likely 99 where there were three cases reported.
But can I force Access to not skip null values. IE. show this:

Jan Feb Mar Apr May Jun July.............Dec Annual
110 1
109
108
107
106
105
104
103
102
101
100
99 3
98 1 5
97 2 5 10
etc

Visually it jumps out at you a lot better that the 110 in July is obviously
a fat finger mistake.
Is this possible to do?

 

[[MVP] S.Clark]

You can accomplish this with an Outer Join. The OJ would be to a table that
contains EVERY temperature that you would like to show on the Left axis.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-