Search results

  1. 1

    Update query: calculated field to other field with SharePoint Lists

    If I open the Frontend, the first time I run the query it seems to work. However, if I want to run the query again the records do not change. Closing and re-opening the Frontend sometimes work. I also get a lock violation error. But this only seems to be the record that is currently selected by...
  2. 1

    Update query: calculated field to other field with SharePoint Lists

    Haha yes. The append query works for me. I am not sure if I understand you correctly. I think this is a price table. In this table you select a product 'omschrijving', the customer and the 'period' from other tables. So you only have a new record for an unique combination of these three fields...
  3. 1

    Update query: calculated field to other field with SharePoint Lists

    Thanks. The commercial prices need to be mutiplied with a certain percentage every year. I use an append query to create new records for the new year, where all the product information is duplicated and the price 'tarief' is multiplied with a certain percentage. This works perfectly. I want...
  4. 1

    Update query: calculated field to other field with SharePoint Lists

    Good morning, I am a beginner in Access and I've built a database for the indexation of commercial prices. In this database I use an update query in which a calculated field ‘calc’ is updated to another field ‘tarief’. This calculated field ‘calc’ is a multiplication of the field ‘tarief’ with...
Top Bottom