Query Formatting

[Deleted member 73419]

Hi,

I've a couple of questions regarding the formatting of query results...

The first is how do you justify the columns? I'd like to center justify some of the columns for ease of reading however the justification buttons are greyed out.

The second is to do with the ordering of numbers. The query returns a numerical value in descending order but the order is a little weird in that they come out like this:
6441
6184
5775
5060
20995
20994

Clearly 20994 is greater than 6441 so I suspect is seeing the first digit of 6 as being greater than 2. Is there a fix for this?

Thanks

 

[June7]

Build a report.

Your data is text so alpha sorting applies - one character at a time. 2 comes before 6 ascending and 6 before 2 descending. Either convert the field to number type or use intrinsic functions to modify the value in query. Val() function will convert to numeric.