Equivalent of Month Function

[Guest]

I have a query that calculates the total hours worked using the Month
function, I would like to create a query that would use the equivalent of the
Month function so I could add number of hours worked for each week rather
than each month. I am sure it is easy but I am stuck !
Thanks for the help

 

[Guest]

Hi Stephanie,

Perhaps one of these links will be of help to you:

On time and how much has elapsed
http://office.microsoft.com/en-us/assistance/HA011102181033.aspx

and
http://office.microsoft.com/en-us/assistance/HA010546621033.aspx#b60


It would be helpful if you could post the SQL statement for your query.


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Albert D.Kallal]

Use the format function

format([yourDate],"ww")

The above will return the week as a number