Search results

  1. U

    Query help

    Dear all, Please see the attachments as we are paying staffs as 26 days basis. If more than 26 days it will be considered as OT eg. (If 28 days they worked than it should consider as 2 OT). I tried to put some formula but facing problem like my query is showing those staffs also 26 days, who has...
  2. U

    Summing in Query

    :p True there is two missing bracket which I have noticed later only. Anyway thanks a lot.
  3. U

    Summing in Query

    Done :) Thanks CBrighton.
  4. U

    Summing in Query

    Received below message, The expression you entered contains invalid syntax You may have entered and operand without an operator
  5. U

    Summing in Query

    Thanks CBrighton, No idea where I can put that code. Please advise.
  6. U

    Summing in Query

    Dear all, Please advise re attachment as I want to show total values in Total earnings and write down the feild with (+) but it is not working. It is working only in the condition if whole feild is filled up with value. Might be I am doing wrong. Help me out.:(
  7. U

    Query problem

    Dear All, I have a query as attached I just want to show "yes" in a 4th field, if all 03 field (HS, MOFA, Ambe) value is True ("Yes"). Your great idea will be appreciated.
  8. U

    User Level

    It will be great help for me too if somebody advise re the same. :)
  9. U

    number vs word

    Hi endri81, In the report design just click in the Field List in toolbar (near to toolbox icon) and select the field (name you given for field for checklist) and drag that field to report. It will workout :)
  10. U

    Query filter problem

    Thanks namliam, Still not getting you. Please advise.
  11. U

    Query filter problem

    Dear All, I have a query like this (attached) I want to filter value like greater than 7% or less than 15%. I tried a lot but not success. Please advise.:confused:
  12. U

    Progress Bar help

    Hi Yarp, Thanks a lot. Appreciated. Thanks to Trevor G too :)
  13. U

    Progress Bar help

    Dear All, I just create a db where progress bar is showing % of total manpower but I have hit a snag in between (coding). It's showing % of total manpower for UAE but how to show % for India and Bangladesh?:confused: Please help me out. Appreciate your response as always.
  14. U

    Trouble with %

    Thaks John Big Booty, Got it. :)
  15. U

    Trouble with %

    Dear All, How can I show the percentage for below? Total = 1183 A = 250 B = 350 C = 155 A - % of total B - % of total C - % of total Please advise.
  16. U

    Help re progress bar

    Dear All, I just create a db where progress bar is showing % of total manpower but I have hit a snag in between (coding). It's showing % of total manpower for UAE but how to show % for India and Bangladesh?:confused: Please help me out. Appreciate your response as always.
  17. U

    Help

    Hi Kryst51, Thanks a lot. It's working now. Regards,
  18. U

    Help

    Thanks Kryst51, But no idea how??? Please advise.
  19. U

    Help

    Dear all, I just want to show sum of the items in the form. I don't have an exact idea about it. Please see the attachment. I want to show value in the form from Item issue record like below, Shirt - Brown = 5 Safety Vest = 3 Looking for your response as always.
  20. U

    Sharing Database

    Thanks apr pillai, I will follow the same instruction. :o
Back
Top Bottom