Pivot Forms Access 97

[Jaye]

When my pivot form is displayed the range below is not in
the correct order. How can I get it to display in
acending order

(blank)
1 - 30 days
121 to 150 days
151 to 180 days
181+ days
31 - 60 days
61 - 90 days
91 - 120 days

Many thanks

 

[Michel Walsh]

Hi,


ORDER BY Val(fieldname)




Val( ) take the string and tries to get a number out of it, but stop at the
first non-numerical thing, so, out of "121 to 150 days", it throws out 121,
numerical.


You actual order is lexicographic, which is standard with text:



a
azz
z


or

1
122
2 ' as string, rather than as number


Hoping it may help,
Vanderghast, Access MVP

 

[Jaye]

Hi Michel,

Thank you for your response. Sadly I am baffled. I have
tried adding Val(Range) to the Pivot properties Order By
But this has made no difference. If you have any more
advise it would be greatly appreciated as this is really
starting to frustrate me if you need any more details ie
What queries the Pivot is running off let me know.

Kindest Regards

Jaye

 

[Michel Walsh]

Hi,


The PIVOT supplies the expression that would create the set of values
that will in turn create fields, it is not intended to ORDER the fields. You
order the fields by their disposition on the form (since the database may
re-order the fields, themselves, to get more compact "row" of data). My
suggestion was only valid for VERTICAL ordering, among records (as I thought
your data was, as presented in your initial message).


Hoping it may help,
Vanderghast, Access MVP