i have a database with a date field [date due].

i want to display the difference of [date due] and the system date like:

data2.recordsource = "select [date due] - " & Date & " as [difference] from transaction"


data2.refresh

grid1.datasource = data2

The grid shows some records and all of this are blank.


could anyone help....