Hi Andreas,

What about creating an index on TTOC(surveydate) ?

Gavin...

>Thanks Gavin.
>
>Good that you confirmed that problem on a completely different PC. It caused some rather unpleasant results on the client side.
>
>The TTOC() solution brings the performance down a bit. My table has a few million entries.