Search results

  1. T

    Assign a value based on order of priority

    Hi I need to update a table field based on a set order of priority of another field. Imagine I have the following table: Customer Brand Primary Customer and Brand are my primary key and I have to assign Primary the value "X" once to any given customer based on a specific order of priority...
  2. T

    Nested recordset reads

    Hi guys I'm trying to process records from a table based on the unique value of one field but my code fails at the last line shown below "Set rst2..." : What am I doing wrong?? Public Function UpdatePrimary() Dim db As DAO.Database Dim rst1 As DAO.Recordset Dim rst2 As DAO.Recordset Dim...
  3. T

    Hi everyone

    Hi all, I just joined the forum as I use MS Access from time to time to resolve various work related data issues when Excel fails me. I live and work in the UK for a large IT consultancy. My specialism is SAP. Tim
Back
Top Bottom