ASP / Access In Frontpage - Simple Select

I am using asp within frontpage in this situation.

I am doing a simple select from one table, the table has a date field, the select should basically show the next 5 upcoming events based on date. I want to use a "current date" variable in there so the events that show are not in the past (i.e. upcoming events, not past).

I created a query in access and used the now() function for the date, but when I do, that the query does not work within the asp page (it does work within access itself).