Today List,This week List & This Month List query

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.

All Forums

Other Forums

MS Access

Today List,This week List & This Month List query

Author

Topic

esambath
Yak Posting Veteran

89 Posts

Posted - 2008-12-02 : 01:31:53

Hi Friends

I have one table

CIS_Report

Id
Name
price
ndate

I want display the query for

Today List,This week List and This Month List MsAccess query.

This is my Test query

SELECT * FROM CIS_Report WHERE ndate = #"&Date()&"#
SELECT * FROM CIS_Report WHERE (((CIS_Report.ndate)<=Now()) AND ((Month([ndate]))=Month(Now())))

kindly please help this one

Thanks and Regards
E.sambath

esambath
Yak Posting Veteran

89 Posts

Posted - 2008-12-02 : 06:01:41

please any body help this query

esambath
Yak Posting Veteran

89 Posts

Posted - 2008-12-02 : 06:02:38

i want disply the <u>This week List</u> query

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources