re-occuring events

[raj chahal]

Hi there,

I'm creating a access database for 'events'. I have created a field for
'date of event', the asp then checks if this date has lapsed, if so it
doen't show the event. All works fine.
The only problem is how do I manage dates that re-occur ? i.e every tuesday
or every 1st tuesay of the month.
The re-occuring event would have some general blurb that applies to all the
dates, but on some occations I may need to add new unique info for
forthcoming events. ie special guest. How would I design the dtatabase
structure and asp code around this senario ?

I hope someone can help with some principles here, Thanks

Raj

 

[Simon Weaver]

Hi

You should add a boolean field that marks re-occuring
events. And design your query to display all such events
Or events that have not passed.

Simon