Search results

  1. S

    Remove duplicate data based on ID

    Hi Guys I am wanting to remove certain parts of data from a table. Here is my data: +-----------+--------------+--------------+ | Unique ID | Product Cost | Product Type | +-----------+--------------+--------------+ | 62208 | £89.99 | Main |...
  2. S

    Duplicate a record into several

    Hi Guys Is there a way to append a record multiple times, if some fields have different values? EG. Title | Name | Surname | Q3 | Q2 | Q1 -------------------------------------------------- Mr | Test | Test | Yes | Blank | Maybe I want to append this record twice but seperate it...
  3. S

    Hi

    Hi guys Getting to know access and already learnt a lot browsing this site, signed up to help others and go gain more knowledge. Thanks in advance!
  4. S

    Looping through numbers to add a value to a field

    Hi guys I was advised to come to this part of the forum as |I would love to do this through VBA: These are my before and after code is ran table: ID, mobile, datetime, unique 1, 07712312312, 14/04/2016 13:02:34, blank 2, 07712312312, 14/04/2016 13:21:13, blank 3, 07712312312, 14/04/2016...
  5. S

    Move unique values from one table to another

    hey guys i am wanting to move unique values from one table to another. My table has ID, Number, date/time, unique the number field will have mobile numbers, i want to be able to press a button to run some vba code and it will find the unique numbers and put a 1 in the unique field if that...
Back
Top Bottom