crosstab query header

[pv]

Hi,

I have a crosstab query in which I would like to show all possible column
values, including those where the value would be null. I understand that I
can accomplish this entering the column values in the query properties under
column heading.
This is working fine; however, the values that I need to enter are 1.0, 2.9,
etc.. The "." is translated to and underscore "_" in datasheet view. I
have tried various combinations to enter value as a string without success.
Some of the attempts include "1.0" , 1 & "." & 0, 1 & "'.'" & 0, 1 & '.' &
0

Any help or suggestions is greatly appreciated.

Thank you

 

[Guest]

I think your best option is to use "1.0", "2.9", "...

But then what you will have to do is run a data conversion in the Value
column of your spreadsheet. So that you wrap that value in a
CSTR(sum([fieldname])) function.

This is untested, but I think the concept should work.

HTH
Dale

 

[Guest]

Wow. I never came across this before. I tried .. just like the old && trick
but that didn't work. I also tried 11/10 in a failed attempt to produce 1.1.

Check this out: ACC: Incorrect Characters in Crosstab Query Column Headings

http://support.microsoft.com/kb/94192

The bad STATUS This behavior is by design.

 

[pv]

I think your best option is to use "1.0", "2.9", "...

But then what you will have to do is run a data conversion in the Value
column of your spreadsheet. So that you wrap that value in a
CSTR(sum([fieldname])) function.

This is untested, but I think the concept should work.

HTH
Dale

--
Don''t forget to rate the post if it was helpful!

Email address is not valid.
Please reply to newsgroup only.

Hi,

I have a crosstab query in which I would like to show all possible column
values, including those where the value would be null. I understand that
I
can accomplish this entering the column values in the query properties
under
column heading.
This is working fine; however, the values that I need to enter are 1.0,
2.9,
etc.. The "." is translated to and underscore "_" in datasheet view. I
have tried various combinations to enter value as a string without
success.
Some of the attempts include "1.0" , 1 & "." & 0, 1 & "'.'" & 0, 1 & '.'
&
0

Any help or suggestions is greatly appreciated.

Thank you

 

[pv]

Hi Jerry,

I had also tried the &&. Thank you for the article. You have confirmed
what I was unable to find in documentation, so now I know.
I will give Dale's suggestion a try.