Microsoft Access PivotChart Help Needed
Posted on 2013-10-01
I have a client who has a few charts where they want data to appear in the category axis in numerical order Ascending from left to right.
They concatenate two fields (Skid and Roll) displayed as Skid "-" Roll. Because of this the values do not sort properly and it causes, for example, Skid 4 - Roll 1 to be followed by Skid 4 - Roll 10 instead of Roll 2.
So I added another field to the record-source query to concatenate only the numeric values of Skid and Roll as an integer to use instead of, or in addition to the existing field.
But then I wound up with 31,32, 33, 34, 35, 36, 37, 38, 39, 40 (when what I want to come next is 310).. so that didn't work.
Then I tried to make it a decimal instead of a dash -- so I wound up with 3.1,3.2, 3.3, 3.4, 3.5, 3.6, 3.7, 3.8, 3.9, 3.1 -- instead of 3.10 because I used the Cdbl function to format it.
Any suggestions? Thanks.