Chimp8471 Registered User. Local time Today, 11:41 Joined Mar 18, 2003 Messages 353 Mar 29, 2004 #1 What is the best way to run a query and group it by week, Sunday to Saturday... i am trying to run the query, i have dates but not week numbers..
What is the best way to run a query and group it by week, Sunday to Saturday... i am trying to run the query, i have dates but not week numbers..
R Rob.Mills Registered User. Local time Today, 06:41 Joined Aug 29, 2002 Messages 871 Mar 29, 2004 #2 DatePart("ww",[Date field]) I believe this gives the number of the week. If not look up datepart in help files and it will tell you.
DatePart("ww",[Date field]) I believe this gives the number of the week. If not look up datepart in help files and it will tell you.
