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.
Eileen MurphyIndependent Application DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Can you post your SQL?

And some sample data for Skid n - Roll n, with desired result?
Assign Skid with valuues of 100, i.e Skid 1 = 100, Skid 2 = 200....... Skid 10=1000. Roll is assigned by one's, Roll 1 = 1, Roll 2=2, etc. Concatenate those value and they should list in order. Skid 4-Roll 1 would equal 401. 402 would come next as Skid 4-Roll 2.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Eileen MurphyIndependent Application DeveloperAuthor Commented:
Great idea. Thanks.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.