P
Paola
I would like to populate a column to display the week
value and not the exact date. Any suggestions?
Paola
value and not the exact date. Any suggestions?
Paola
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Viescas
Weekno: Format([MyDate], "ww")
--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
F
fredg
I would like to populate a column to display the week
value and not the exact date. Any suggestions?
Paola
Do you mean the week of the year (1 - 52/53)?
=DatePart("ww",[DateField])
P
Paola
Thanks for your help with the weekday solution. I would
like to group by week but display the week with mm/dd/yyyy
versus ww.
Paola
like to group by week but display the week with mm/dd/yyyy
versus ww.
Paola
-----Original Message-----
I would like to populate a column to display the week
value and not the exact date. Any suggestions?
Paola
Do you mean the week of the year (1 - 52/53)?
=DatePart("ww",[DateField])
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.