I have problems sorting my records probably. Here is the case:

I have a field named 'Price' and a field named 'Tax'. The price field contains numbers while the tax field contains either 'within' and 'without'. Then when I'm displaying my records DBman automatically corrects the prices without taxes, so that all prices includes taxes. And here is the problem: When I'm sorting by price, the results are naturally sorted by the numbers in the price field in the db, and not the numbers displayed to the user. So what I would like to do, is having the numbers corrected somewhere in the display process, so that the result will be that the records are sorted by the numbers displayed.

I really need help with this one!

Regards,

Alex

Sounds like a lot of work to me, but I'm no expert at all.

I think I would have it changed straight away when adding the record. (Before writing it to the database) So you could easily use the sort routine afterwards.

Lex