Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
esambath
Yak Posting Veteran
89 Posts |
 Posted - 2008-12-02 : 02:00:48
|
| Hi Friends I have one tableCIS_ReportIdNamepricendateI want display the query for Today List,This week List and This Month List MsAccess query.This is my Test querySELECT * FROM CIS_Report WHERE ndate = #"&Date()&"#SELECT * FROM CIS_Report WHERE (((CIS_Report.ndate)<=Now()) AND ((Month([ndate]))=Month(Now())))kindly please help this oneThanks and RegardsE.sambath |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Today List,This week List & This MonthList MsAcces