sort numbers in column from query

[megatronixs]

Hi all,

I have query that has a column to calculate days passed. If I want to filter the column to show the number by order, all I will see that it starts with 1 and then it skips 2 to start with 10. How can I filter it to show correct? As this is not a real column in the table, it looks like it will be more dificult.

Greetings.

 

[Minty]

You may need to run a second query on your calculation query, or use the calculation in a sub query then order the result.

 

[JHB]

Can't you convert the calculated value to a integer or long?

CInt(YourCalculation)
CLng(YourCalculation)

 

[megatronixs]

Hi all,

JHB's tip did the trick
Thanks a lot all of you for your great help in this great forum

Greetings.