Use the alias.field structure of the sql result. did you put the result into a cursor or just leave it in the original table?

>If i populate a grid with an SQL command how what to i set the columns controlsource source property to.
>
>I tried something like select a1, a2, a3 from myfile as the recordsource.
>
>Thanks,
>
>Scott