Newbie here doing as project for a school.

I need to be able to only display current and upcoming events. and not show events all ready past automaticly

IS it also possible to have the asp page to delete records in database automaticly if thay are older than the current date.

2) At moment all records are shown
How do I setup some buttons so that when clicked on thay do some of the following

a) Only show events for the current school term
b) only Show events for the next term
etc
c) Only show Events that are Holidays or exams or other.

Thanks
Stuart

If you use a query/view to extract your data, you can set up the query to show only those dates that are greater than or equal to todays date. In Access this can be done with the >=now() criteria in the query. With respect to auto delete. I am not sure, I have heard of people calling for a page on the website that displays nothing and when called performs a delete or clean up function.

Wm. Kent Steelman