how do u select data by upcoming month?

P

pb

tablename: TABLE1
fields: LASTNAME, FIRSTNAME, DATEDUE

i have hard set DATEDUE which is sometime in the future
how do select these dates by upcoming month?

something like SELECT * FROM TABLE1 WHERE DATE()>NOW AND DATEDUE =
September???
 
E

Eric D via AccessMonster.com

Select *
From Table1
Where Month([DateDue]) = Month(Date())+1

This should display records with a DateDue of Sept.
 
Top