date problem

[Jean-Paul]

Hi
In following SQL i have a date-problem:

sql = "SELECT [Adressen metaal].Datum_bezoek, [Adressen
metaal].Naam, [Adressen metaal].bezoeken, [Adressen metaal].Datum_bezoek
FROM [Adressen metaal] WHERE [Adressen metaal].Datum_bezoek < Date And
[Adressen metaal].Bezoeken = " & True & ";"

I think I must change the Date part and add some # things...

But, I don't know how exactly it is done?

Anybody wants to help?

Thanks
JP

 

[Al Campagna]

Jean-Paul,
I couldn't test this, and I'm assuming that you want to find records
where the Datum_bezoek is less than the current system date/time.
And I'm assuming the sql is correct except for the Where...Date
Try
< Date()
Without the () Access may be looking for the value for a field named
Date.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."