It sure looks straight forward butI keep getting errors.
Ultimately, I want to group sales by week, but in just testing this function I keep getting an error. Read and reread the help files....
Any insight or comments are greatly appreciated. Thanks!
SalesDate is a date/time data type
Sales is a double.
DatePart("ww",[SalesDate])
in field of my query : Expr1: DatePart("ww",[SalesDate])
qry results :
SalesDate Sales Expr1
1/1/2003 1 #ERROR
Ultimately, I want to group sales by week, but in just testing this function I keep getting an error. Read and reread the help files....
Any insight or comments are greatly appreciated. Thanks!
SalesDate is a date/time data type
Sales is a double.
DatePart("ww",[SalesDate])
in field of my query : Expr1: DatePart("ww",[SalesDate])
qry results :
SalesDate Sales Expr1
1/1/2003 1 #ERROR