Sql help

[Paul C]

Hi
How can I select a record only when the expirery date has not past

SELECT record From a tble.records where the endDate is greater than
todays date

Thanks Paul M
PS I am using an access database

 

[Jon Spivey]

Hi,
SELECT * FROM Table Where DateField > Date()

Cheers,
Jon

 

[Paul C]

Thanks Jon
Best wishes
Paul M

Hi,
SELECT * FROM Table Where DateField > Date()

Cheers,
Jon