thanks a million times. it worked and i never thought it would be that easy.

now, i hope you can solve this problem.

i have date field in my database. its name is [date due]. in the dbgrid,
i want to show its difference with the system date like :

data1.recordsource = "select [date due] - " & date & " from [transactions]"
data1.refresh

about 5 to 10 records will appear in the grid. but all blanks.

any other way???