By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,826 Members | 2,443 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,826 IT Pros & Developers. It's quick & easy.

Negative Zero shows in Pivot Table but is missing in Crosstab

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.