Neturiu Access po ranka, bet jei gerai pamenu sintakse, tai:

 SELECT ArtGroup.ID, ArtGroup.Code, ArtGroup.Description, IIF 
(isnull(artGroup.fkBitmap);0;1)  FROM ArtGroup;



"Kaksht" <kaksht@cianetikrasmuilas.com> parašė naujienų 
news:hjscs7$5i3$1@trimpas.omnitel.net...
> jei nesunku uzmesk aki ar taip ar dar selecta reiktu rasyti? cia 
> supaprastintas variantas tik isrinkimo
>
> SELECT ArtGroup.ID, ArtGroup.Code, ArtGroup.Description, (IF 
> (ArtGroup.fkBitmap = NULL) OR (ArtGroup.fkBitmap = '0')) '1' ELSE 
> (ArtGroup.fkBitmap) )
> FROM ArtGroup;
>
> --