Microsoft Access PivotChart Help Needed

Posted on 2013-10-01
Medium Priority
Last Modified: 2013-10-02
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.
Question by:Eileen Murphy
LVL 26

Expert Comment

ID: 39538498
Can you post your SQL?

And some sample data for Skid n - Roll n, with desired result?
LVL 22

Accepted Solution

Flyster earned 2000 total points
ID: 39538509
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.


Author Closing Comment

by:Eileen Murphy
ID: 39540371
Great idea. Thanks.

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

619 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question