 |
28-Jul-2006, 08:39 AM
|  | Guest | | | | | | | | | | week number as date
heI have converted dates to week number in a preceding query, then in a Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13681-week-number-as-date.html
Crosstab query grouped by week number.
In the report based on teh crosstab query I would like to show the Week
commencing date. I would prefer not to add extra fields to the crosstab
query, can I do it direct in the report? * Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh! |
28-Jul-2006, 08:39 AM
| | Guest | | | | | | | | | | RE: week number as date
This will display the week of the year and the week date. To adjust which
day of the week you will display as the "Week commencing date" change the
number in the formula. The '+2' put the Monday date.
Format([YourDate],"ww") & " - " & [YourDate]-Format([z],"w")+2 Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13681
"steph" wrote:
> heI have converted dates to week number in a preceding query, then in a
> Crosstab query grouped by week number.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13681
> In the report based on teh crosstab query I would like to show the Week
> commencing date. I would prefer not to add extra fields to the crosstab
> query, can I do it direct in the report? |
28-Jul-2006, 08:40 AM
| | Guest | | | | | | | | | | RE: week number as date
Not sure I'm following this. What is the [z]?
"KARL DEWEY" wrote:
> This will display the week of the year and the week date. To adjust which
> day of the week you will display as the "Week commencing date" change the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13681
> number in the formula. The '+2' put the Monday date.
>
> Format([YourDate],"ww") & " - " & [YourDate]-Format([z],"w")+2
>
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13681
> "steph" wrote:
>
> > heI have converted dates to week number in a preceding query, then in a
> > Crosstab query grouped by week number.
> > In the report based on teh crosstab query I would like to show the Week
> > commencing date. I would prefer not to add extra fields to the crosstab
> > query, can I do it direct in the report? | 
Support Us! Become a Promoter! | | Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh! |
 (View-All)
Members who have read this thread : 0
| | There are no names to display. |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Tools | Search | | | | | Display Modes |  Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is On
| | | |  | » Active Discussions | | | Amrit Today 22:24 PM 1 Replies, 319 Views | | | | | | | | | | | | | | | | | | | | | | | | | Panjabi Today 02:27 AM 11 Replies, 238 Views | | » Books You Should Read... | | | |
