Yes workday is a date field but it is formated to show the week number of the year with expresion: Workday: Format([Workday];"yyyy-mm-ww")so given the day of a workday 31/1/2011 it returns 2011-01-6
am i helpful?
To MichaelRed i think you undrestand the problem but i cannot quite come to the...
I d like some help please
i have an example query:
SELECT TblWorkdays.WorkdaysID, TblWorkdays.Workday
FROM TblWorkdays;
given the "Workday" like Format([Workday];"yyyy-mm-ww"),
i would like to count just the number of days there are in week like:
mon tue wed thu fri sat Sun =result
1 2...
code of my query is:
SELECT ypaliloi.???????, Format([??????????????],"yyyy-mm-ww") AS [??? ????????], Sum([???????????]+[????]) AS [???? ??????????? ???????? ?????????], Count(argies.?????) AS ?????, (34-([?????]*8.5)) AS [?????????? ?????????], [???? ??????????? ...
Hello,
i would like some help in my database,
i want to calculate workhours during week then per month, for employes that works shifts aproximately 34 per week. The theoretical hours per emloyee is 34, and the real work hours show up already in a query sum [therhours]-[worhours] order by...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.