Negative Zero shows in Pivot Table but is missing in Crosstab

[Joe Harris]

I've searched everywhere but can't find a KB article or forum message
about this one...

Excel Pivot Tables differentiate between +0 (zero) and -0 (negative
zero)and now that I've moved over to Access 2002 (from 97) and I've
found the same thing.

However, I've used a Pivot Table to produce a summary across a
standard distribution (-1 to 1 in increments of 0.05) and this works
fine (both zeroes shown) but when I attempt to recreate this with a
Crosstabe query I *lose* the +0 row.

It's definitely gone because it's missing no matter what field I use
in as the Crosstab Value. All other values are identical so it's
definitely not been totalled into another row.

I'm at a total loss... Anyone come across this before or know of the
solution?

I now *need* both zeroes due to precedent and as the grouped column is
a calc I'd prefer not to just put an IIF around it as it runs over 1m+
rows.

Thanks,
Joe

[david epsom dot com dot au]

Are you saying that you are missing data in the crosstab?

You can specify the column names in the crosstab, to make
sure that you always get all the columns that you need,

but no way are you going to get different values for +0
and -0: the cross tab uses database sort order for grouping,
and database sort order will group +0 and -0 together.

(david)
"Joe Harris" <no**********@hotmail.com> wrote in message
news:1e**************************@posting.google.c om...

I've searched everywhere but can't find a KB article or forum message
about this one...

Excel Pivot Tables differentiate between +0 (zero) and -0 (negative
zero)and now that I've moved over to Access 2002 (from 97) and I've
found the same thing.

However, I've used a Pivot Table to produce a summary across a
standard distribution (-1 to 1 in increments of 0.05) and this works
fine (both zeroes shown) but when I attempt to recreate this with a
Crosstabe query I *lose* the +0 row.

It's definitely gone because it's missing no matter what field I use
in as the Crosstab Value. All other values are identical so it's
definitely not been totalled into another row.

I'm at a total loss... Anyone come across this before or know of the
solution?

I now *need* both zeroes due to precedent and as the grouped column is
a calc I'd prefer not to just put an IIF around it as it runs over 1m+
rows.

Thanks,
Joe