Hi!

I'm trying to create an event DB. I have a form which take in the data of
the event, title, and information about the event. Once submited it will
send to an Access DB. My question is, how can I get it to display just the current event and from today and on ward?

Thanks!
-Dave

it depends on what you mean.......

if you just want to select events that dated today or later then simply use...

SELECT * FROM tblEvents WHERE EventDate >= Date()

but what do you mean by current event, do you mark this as current yourselves or what?


Cheers

Leed

:: Son, im Thirty.... ::

Thanks, that did it.
-Dave

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
it depends on what you mean.......

if you just want to select events that dated today or later then simply use...

SELECT * FROM tblEvents WHERE EventDate &gt;= Date()

but what do you mean by current event, do you mark this as current yourselves or what?


Cheers

Leed

:: Son, im Thirty.... ::
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>