Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: manos39
  • Order by date
  1. manos39

    Count calendar days per week in a Month given a date

    Super!! thank you very much!
  2. manos39

    Count calendar days per week in a Month given a date

    Thank you! i ll let y know when i succeed!!
  3. manos39

    Count calendar days per week in a Month given a date

    I m not familiar where to put code! please help me.
  4. manos39

    Count calendar days per week in a Month given a date

    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...
  5. manos39

    Count calendar days per week in a Month given a date

    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...
  6. manos39

    Calculating workhours per month

    code of my query is: SELECT ypaliloi.???????, Format([??????????????],"yyyy-mm-ww") AS [??? ????????], Sum([???????????]+[????]) AS [???? ??????????? ???????? ?????????], Count(argies.?????) AS ?????, (34-([?????]*8.5)) AS [?????????? ?????????], [???? ??????????? ...
  7. manos39

    Calculating workhours per month

    I have made a link to the database for downloadif that s convinient.
  8. manos39

    Calculating workhours per month

    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...

Part and Inventory Search

Back
Top