Hi,

Im trying to select the records in a table that are or after the current date.

This is the SQL I am using ...

rsDiary.Source = "SELECT * FROM tblEvents WHERE DateOn > " & Date & " ORDER BY DateOn ASC"

but however it still returns the dates from last year.

Does anyone know an easy way of doing this?

Please, only post your question once on the site.

Martha Graham