Information générale
Titre:
Displaying calculated field in dbgrid
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....
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement