display records >(higher) than todays date?

[Don Pacino]

hi,

I have a vacancies table which displays vancanies added into a database. I
want to display the records that have todays date or higher in the DATE_EXPIRY
column. I know you can mess around with dates with dreamweaver, so does that
mean i need to do something in access?

I dont know, you tell me.

[Don Pacino]

hi,

sorry ihave just found an excellent tutorial with the answer

[url]http://www.webthang.co.uk/tuts/tuts_ud4/utrix1/utrix1_1.asp[/url]

BUT, i have ONE MORE question, upon insertion of the data, i will have a drop
down box to ask the user how many days they want to display the advert.

this will be arranged in the drop down as : 3 days, 7 days, 10 days, 14 days

Now say if the user selects they want to advertise the ad for 3 days.

I want the date inserted in the database to be from 3 days from the current
date!!!

hope this is making sense.

Can you help?