Selecting with aDate >= now()

[BPetro]

When the database is MSAccess, what's the best way to do this? I can think of two ways:
1. In Access, create a query that says date >= today. Then in SQL just use that query.
2. In VBScript build the SQL that handles date >= today.

Having said I can think of these two ways, should not imply that I have ever built the code to do this. Please describe what you see as the best way, and if you feel really helpful I'd love to see a touch of sample SQL/VB code.

Thanks!

 

[TonyU]

Select * from table\query where date >= #" & date & "#"

[tt]
^{"The only ideas that will work for you are the ones you put to work."}
[/tt]
​