Eileen Murphy
asked on
Microsoft Access PivotChart Help Needed
Hey Experts!
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great idea. Thanks.
And some sample data for Skid n - Roll n, with desired result?