Sorting Problem

[jcruzAME]

The column in the query that is sorting oddly is an expression that does Format(Value, "STANDARD"). Instead of sorting ascending or descending, it is sorting like this:

• 1,526,222
• 167,254
• 17.56
• 1,800,332
• 200.45
• 2,364,209
• 240,000

and so on. The value was initially currency but they don't need the dollar values in their display, they just want straight numbers.

*EDIT: After posting this I right clicked the column and it's giving me the option to sort it A to Z instead of smallest to largest. Is this the result of the Format function?

Any advice?

 

[spikepl]

Output of FORMAT function is a string, and your sort is a perfectly normal alphabetic sort.

What is the point of messing wth formats in the query? Display formats for desired fields you can set on the form or report.

 

[jcruzAME]

I totally forgot about setting the format of a column in the query. My mistake.

/thread