I got this off a group and it works in a crosstab query to group hours 
worked from Sunday thru Saturday into a total hours for the week.

My question is, what does the minus sign do in front of the Weekday 
function; is it a switch that cause it to collapse the date into a single 
column? Having no sign or a + sign returns a different but same result if 
there is no sign or a + sign, neither returns a single column for the week.

DateAdd("w",-Weekday([DateWorked],1)+1,[DateWorked])

Thanks John 

DateAdd() can subtract from a date as well as add.  Have you tried removing
the minus sign to see what it does to the results?

john wrote:
>I got this off a group and it works in a crosstab query to group hours 
>worked from Sunday thru Saturday into a total hours for the week.
>
>My question is, what does the minus sign do in front of the Weekday 
>function; is it a switch that cause it to collapse the date into a single 
>column? Having no sign or a + sign returns a different but same result if 
>there is no sign or a + sign, neither returns a single column for the week.
>
>DateAdd("w",-Weekday([DateWorked],1)+1,[DateWorked])
>
>Thanks John

-- 
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200705/1

Yes, that what Iwas saying in the 2nd part of my question, it does not 
appear to act as a math function, more like the  + & - on the file system, 
except it collapses or sums the hours of a week into one column with the - 
sign, but not without it.

john


"ruralguy via AccessMonster.com" <u12102@uwe> wrote in message 
news:71c5819f72803@uwe...
> DateAdd() can subtract from a date as well as add.  Have you tried 
> removing
> the minus sign to see what it does to the results?
>
> john wrote:
>>I got this off a group and it works in a crosstab query to group hours
>>worked from Sunday thru Saturday into a total hours for the week.
>>
>>My question is, what does the minus sign do in front of the Weekday
>>function; is it a switch that cause it to collapse the date into a single
>>column? Having no sign or a + sign returns a different but same result if
>>there is no sign or a + sign, neither returns a single column for the 
>>week.
>>
>>DateAdd("w",-Weekday([DateWorked],1)+1,[DateWorked])
>>
>>Thanks John
>
> -- 
> HTH - RuralGuy (RG for short) acXP WinXP Pro
> Please post back to this forum so all may benefit.
>
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200705/1
> 

The function you posted returns the [DateWorked] date adjusted to the
previous Sunday's date.  

john wrote:
>Yes, that what Iwas saying in the 2nd part of my question, it does not 
>appear to act as a math function, more like the  + & - on the file system, 
>except it collapses or sums the hours of a week into one column with the - 
>sign, but not without it.
>
>john
>
>> DateAdd() can subtract from a date as well as add.  Have you tried 
>> removing
>[quoted text clipped - 12 lines]
>>>
>>>Thanks John

-- 
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200705/1

Hi John,
The minus sign just means past date here and mathmatically substraction. 
For your expression:
DateAdd("w",-Weekday([DateWorked],1)+1,[DateWorked])
The return value of Weekday is substracted by 1. If the result is minus and 
the value is N, the DateAdd expression means that get the date of the past 
N days of the current date.  In this case, it has the same result as 'd'.

Could you please let us know what your exact requirement is?
If you have any other questions or concerns, please feel free to let me 
know.
Have a good day!

Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications

If you are using Outlook Express, please make sure you clear the check box 
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly. 


Note: The MSDN Managed Newsgroup support offering is for non-urgent issues 
where an initial response from the community or a Microsoft Support 
Engineer within 1 business day is acceptable. Please note that each follow 
up response may take approximately 2 business days as the support 
professional working with you may need further investigation to reach the 
most efficient resolution. The offering is not appropriate for situations 
that require urgent, real-time or phone-based interactions or complex 
project analysis and dump analysis issues. Issues of this nature are best 
handled working with a dedicated Microsoft Support Engineer by contacting 
Microsoft Customer Support Services (CSS) at 
http://msdn.microsoft.com/subscriptions/support/default.aspx. 
====================================================== 
When responding to posts, please "Reply to Group" via 
your newsreader so that others may learn and benefit 
from this issue. 
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights. 
======================================================

Hi John,
How about this issue? If you need further assistance, please feel free to 
post back. 

Have a good day!

Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications

If you are using Outlook Express, please make sure you clear the check box 
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly. 


Note: The MSDN Managed Newsgroup support offering is for non-urgent issues 
where an initial response from the community or a Microsoft Support 
Engineer within 1 business day is acceptable. Please note that each follow 
up response may take approximately 2 business days as the support 
professional working with you may need further investigation to reach the 
most efficient resolution. The offering is not appropriate for situations 
that require urgent, real-time or phone-based interactions or complex 
project analysis and dump analysis issues. Issues of this nature are best 
handled working with a dedicated Microsoft Support Engineer by contacting 
Microsoft Customer Support Services (CSS) at 
http://msdn.microsoft.com/subscriptions/support/default.aspx. 
====================================================== 
When responding to posts, please "Reply to Group" via 
your newsreader so that others may learn and benefit 
from this issue. 
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights. 
======================================================