[AccessD] report subheadings

Susan Harkins harkins at iglou.com
Sat Jul 12 13:04:17 CDT 2003


>   YourDateField
>     Ascending, no header or footer
>   =Format([YourDateField],"ww",2,2)
>     Ascending, header and/or footer

==========Thanks Gustav, I'm already using this -- I thought it would help
me get where I wanted to go, but I haven't gotten there yet. :) What I'm
trying to do is return the full date of that week's Monday -- for instance,
July 16, is in the 29th week. I want to return July 14, 2003 -- the date of
the 29th week's Monday.

Susan H.



More information about the AccessD mailing list