Hello Gavin & Sergey,

Thanks for the help, the select now updates the field properly.

>Hi James,
>
> You need to convert barn to STR(barn,4)
>
>

>SELECT IIF(hbstb<>" ",hbstb,IIF(tent<>" ",tent,STR(IIF(barn>0,barn,0),4))) as stable from stnhorse order by hip_no
>

>