Thanks for reply.

used:

select distinct [service date] from [errormode detailed]

It resulted in two kinds of posts:

Service date

0

20030101

20030102

.....

Then I made this to controll any 0 posts

CASE WHEN ( {A} is null)

THEN...

Need to correct my self abit.

I said it worked well under winsql. That is a truth with modifications...

Only when I add the where clause does it work, if I exclude...