Search results

  1. V

    Hi

    Hi everyone, Could you please help with one issue. I have 2 forms: timesheet and basesalary with fields: BasesalaryForm 1. Full Name 2. D/M 3. BaseSalary 4. Month 5. Year 6. WorkDays timesheet 1. Full Name 2. Month 3. Year 4. WorkDays when I fill "basesalary" I try to write function...
    • Vugar
    • Thread
    • Replies: 2
    • Forum: Forms
  2. V

    Copy to table

    I can't give unique to field because it's SP list
  3. V

    Copy to table

    Could you please tell how I can ignore copy duplicate data in Append query
  4. V

    Copy to table

    every when query run all data will copied and duplicate data
  5. V

    Copy to table

    My query it's sum of fields and there not unique ID.
  6. V

    Copy to table

    Hi everyone, I take information from many tables by query and I try to copy data to linked (SP) table. I copied by Append Query. One problem that append query duplicate data. Do you know how set rule that query not copy duplicate, copy only new data. thank you
  7. V

    Hi

    it's work. but information I take from many tables by query. and I try to copy data to linked table. I copied by Append Query. One problem that append query duplicate data. Do you know how set rule that query not copy duplicate, copy only new data. thank you
  8. V

    Hi

    yes I can export to SP list.
  9. V

    Hi

    please see attachment I didn't find
  10. V

    Hi

    But I didn't find Move Data option, there only export to Share Point list. no updating information.
  11. V

    Hi

    Could you please tell way how I can do it. I know only append query but it duplicate data.
  12. V

    Hi

    I can copy my query to SP one time. I would like to updated my data in SP every time when I'll add information to table.
  13. V

    Hi

    Access and SP is 2013
  14. V

    Hi

    Hi everyone, Could you please help with one issue. Can I connect my DB with SharePoint list. So when I will add any information to my DB it was copied to list in SharePoint. Thank you in advance.
  15. V

    Hi everyone

    Thank you very very much I find :-)
  16. V

    Hi everyone

    Could you please check it: IIF([SM/SS/S] ="S",[SumOfBaseSalary], IIF( [SM/SS/S] = "D", [SumOfBaseSalary] / [SumOfBaseWorkDays] * [SumOfWorkingDays] ,0)
  17. V

    Hi everyone

    thank you, but there sum mistake in operator.
  18. V

    Hi everyone

    I try to create Salary DB and have one problem. please see below: FullName D/M BaseSalary BaseDay WorkDays Salary XX D 500,00 20 22 YY M 500,00 1 15 I want writh formula: 1. If ("D/M" ="D") then...
  19. V

    Hi

    Hi everyone, Could you please help with one issue: I have a database Time Sheet DB. weekly staff send their Time Sheets (Access file) data and import them unto my Time Sheet DB. how to do it so that the data is automatically loaded? thank you very much
  20. V

    Hi

    Could you please tell if you have simple method to refresh all data when I will close some form? And one more my main form with (Month) field Me.Requery
Back
Top Bottom