Search results

OK, so the formatting didn't come out for my table example but you should be able to work it out.

OK, second time lucky... I have a table with three fields: Customer Brand Primary Customer and Brand together form the primary key. Brand can have values 2,3,4, 8 and 13. Customer and Brand have values but I have to assign a value "X" to the field "Primary" but based on a specific order of...

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...

I noticed my error, Im new to this but the reason for using a function comes later in the code, but your right a query would have been easier for this part.

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...

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