Thanks!!!

>Add another field called sortsequence and set it so you can have the output whatever way you want.
>
>>In my example, the numbers 270, 280, 290, 320, 450 and 545 are just sample set of records. In the actual report, all account codes will show if the amount is not 0. If account code 201 has an amount greater than 0, code 301 should appear after it.. and so on.
>>
>>Thanks again!
>>
>>
>>>To rephrase my question: What's the logic for the order of the numbers which are not x0x, meaning where the second digit is NOT 0? In your case these numbers are 270, 280, 290, 320, 450 and 545?
>>>
>>>NB! Please enable Auto quote, so that I can see the earlier messages when I reply. Hover the mouse over Message view setup in the upper right corner of the message area, and the option will appear.
>>>
>>>>Thanks for your reply sir Tore.
>>>>
>>>>I need to generate a balance sheet report where 201 is the account code for office equipments and 301 is the code for accumulated depreciation for office equipments. My user wants 301 to come after 201, and 304 (accumulated depreciation for motor vehicles) to come after 204 (motor vehicles) and so on.
>>>>
>>>>I am actually looking for a SELECT-SQL statement to do this but can't figure out how.
>>>>
>>>>Thanks!