dear sir, how to change the 'month' automatically base on current month after the 'from' in sql statement? eg. i have Jan-Dec table in MS Access..so now is May, so the data will be automatically stored in 'PayMay' table, then next month June,again data will auto store in June table....i have tried the following but failed, please help,thanks...
sql="select * from Pay(month(now))" ------------------------ Yahoo! Groups Sponsor ---------------------~--> Yahoo! Domains - Claim yours for only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/saFolB/TM ---------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
