Search results

  1. M

    Question Getting syntax error in the query

    My bad.. I just realized that "FROM" key word was missing from the outer most query. Thanks Mounika
  2. M

    Question Getting syntax error in the query

    Hi Lag bolt, Thanks for the immediate help on that day, I discussed your suggestions with our director but he asked to implement in a different way.. I wrote a query below , but it's giving some syntax errors , can u please help to resolve them. I am getting the below error , can you please...
  3. M

    Question How to get the Total spent hours of the employee

    Hi Lagbolt, Appreciate your help regarding the solution. I guess, your solution holds good for a period of time. Example: To generate a report on weekly time an employee has spent at office. In our case, we are looking to generate a report which gives daily time spent by each employee at...
  4. M

    Question How to get the Total spent hours of the employee

    Hi Team, I am facing one problem while calculating the number of hours an employee spent in the office. Each employee will have a swipe card and the swipe data is stored in an .mdb file. Some employees will have different shifts and may come after 6pm and will go next day 5 am , while...
Back
Top Bottom