Recent content by aliikhlaq2006

  1. A

    Overtime

    it work for me thank you i need some more help in same. i want to set the parameter what is the total overtime hours in a specific month for each employee. i tried through group by but its give error and as on last month the 2nd shift will have time in next day how i will manage this in parameter
  2. A

    Overtime

    i have attached a required screenshot
  3. A

    Overtime

    I have query that is based on the in and out time of employees. I want to calculate the overtime of the employee by subtracting the out time with in time and if the result is more than the standard hours than shows the extra time as result
  4. A

    Max function not working

    There is no error it gives all result not select the MAX date in both cases
  5. A

    Max function not working

    I need a result which displays the MAX date but its not working I also try to run without the subquery "Datesw" and use field but not works for me
  6. A

    Report with Opening and Closing Balance

    Yes i do the same thing but not worked but the file he send me working in that may be i have put that in my huge database which carries many tables and queries. Overall thank you both you guys. I just need another favor can you please make this query explain to me step wise
  7. A

    Report with Opening and Closing Balance

    i think you should make a query in the database which i attached and send me that because i am trying but no success
  8. A

    Report with Opening and Closing Balance

    I wand a query in which the closing balance automatically transfer to the opening balance with the start of the new month, so query become Opening balance+Advance Taken-Advance payback = closing balance. For this i have attached the file with this post.
  9. A

    Fix the Subform in Form

    I want to fix the number of rows of sub-form in a form even if there is no record for printing i have attached a sample which i want it on every record in a form
  10. A

    Filter in expression builder

    It worked for me and i have seen that you put where in the overtime query and a parameter
  11. A

    Filter in expression builder

    yes and i want to filter monthly
  12. A

    Filter in expression builder

    The date parameter in a calculated express builder field as i mentioned the red color
  13. A

    Filter in expression builder

    I have attached my database file please look. Goto the salary Calculation query there you will find a table OvertimeExp. This is the table where i want to set parameter to run salary every month
  14. A

    Filter in expression builder

    My question is how to filter or set parameter in calculated expression builder for example i have this field calculated Round(Nz(([SalaryData]![BasicSalary]/([SalaryData]![StandardHrs]*[SalaryData]![StandardDays]))*[SumOfOvertimeHrs],0),0) I want to set the date parameter on the red color...
  15. A

    Round Function

    I am basically totally a new in access and just testing my skills i not understand the 1st solution but the 2nd one work for me. Thank you so much
See more
Back
Top Bottom