hi i connect to a oracle database and i i do the
following select
select distinct(book)
from book_table
where trun(date)=trunc(sysdate-1)

it returns a column of with 3 rows in it
what i have is a form that has 3 text boxes on it
i want to put the first row value on textbox 1
and the second row value in txt box 2
and so on
can anyone advise how

cheers

andy