Sort Order

[khurram7x]

Hi,

Another question, on top of my first question already in Table forums.

I've problems setting up a sequence/sort order in CrossTab Query. I want to display result in CrossTab in a sequence as shown in 'ActualTable' screenshot, but I'm not able to order/sort as i want for SubDiscipline row and Step column.

Attaching screenshots. How to deal with it please??

Regards,
Khurram

 

[plog]

Ha ha, I posted to your other thread and addressed this issue without even knowing you made this post. The answer is here:

http://www.access-programmers.co.uk/forums/showthread.php?t=280506

You are storing your data with the wrong type. Further, I don't know what you are trying to accomplish with a cross-tab. Your not in Excel any more Dorthy, most likely this query is unnecessary and just a way to get you to a format you recognize and get you to a familiar place.