Question Date....?

[Jcode]

I have a database with when memberhsips expire.How would i make the members whose information that expires within a month of the date in the databse show on a table

For example the program would list the people whoose membershipe xpires within the next month in a datagrid

 

[Jcode]

Please feel free to use google at any time.. You are, after all, only seeking to know what the function is in Access that returns the current date-time, yes?

i.e. Show some effort that youre prepared to help yourself and others will be far more inclined to help you
(the answer was actually in this thread, if you'd read it)

Thanks, its kind of hard to explain...I dont mean TODAYS acutal date(the 11th) i mean the date whenever the user acces the program

so the program would get "todays" date regardless..so the program would work if today was the 8th ,20th,30th or whatever..It would sitll get TODAY's date

 

[cjard]

Youre thinking about it way too much. I already gave you a query that works in Oracle. I already told you to go and find out what the Access equivalent of Oracle's SYSDATE is. Try google..

 

[JuggaloBrotha]

Thanks, its kind of hard to explain...I dont mean TODAYS acutal date(the 11th) i mean the date whenever the user acces the program

so the program would get "todays" date regardless..so the program would work if today was the 8th ,20th,30th or whatever..It would sitll get TODAY's date

A simple google search of 'MS Access Functions' had this page listed first: http://www.techonthenet.com/access/functions/

On that page there's a section of Access functions that has to do with Dates and Times, one of which being exactly what you need: http://www.techonthenet.com/access/functions/date/date.php