G gsrai31 Registered User. Local time Today, 08:00 Joined Aug 30, 2003 Messages 44 Mar 9, 2004 #1 In excel we could use function "=weeknum(cell Ref)" to workout week number based on a particular date, what do I need to do be able to have this function in expression builder in access 2000? or is there another way to do this? GS
In excel we could use function "=weeknum(cell Ref)" to workout week number based on a particular date, what do I need to do be able to have this function in expression builder in access 2000? or is there another way to do this? GS
ColinEssex Old registered user Local time Today, 08:00 Joined Feb 22, 2002 Messages 9,314 Mar 9, 2004 #2 Format([DateField],"ww") Col
G gsrai31 Registered User. Local time Today, 08:00 Joined Aug 30, 2003 Messages 44 Mar 9, 2004 #3 Thanks Colin