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  SQL statement for returning weeknumbers

Author  Topic  willian Starting Member 1 Post Posted - 2001-10-25 : 04:42:34 Hello, I have to build an Access application which can return figures by weeknumber. SQL has statements like MONTH and YEAR, but not something like WEEK. Is there an solution for in SQL/Acces97/Access2000? Who can help me???