I am trying to write a function that will return the week number of a month. For instance Week 1, Week 2...I have tried writing an if statement, but I get a funky date in return. This is for a week over week view in MS Access on a report. I need the function or expression or conditional macro to make , for example 11/01/2002-11/02/2002, would be week 1", 11-03-11-09 would be "week 2" and so forth. I would use the on format macro(or anything that works I suppose. My last resort is to make a table and link it on the query level. That will introduce human error however. I greatly appreciate any help in this.