Search results

  1. Y

    Setting field type for mixed content

    Hi, I have an excel file coming from a 3rd party supplier as a source. One of the fields in the excel contains serial numbers, which are in most cases just numbers but occasionally there are cells which begin with characters, followed by numbers. When I link the excel to Access (2016), the...
  2. Y

    Calculating differences between table entries

    Hello, I have an Access database which stores data pulled in by another program from several machines in several locations. The data contains a date of the data reading at random intervals (random, because occasionally the connection fails due to machine being offline), the ID of the machine...
  3. Y

    Delete duplicates without primary key

    Hi, I bounced into a big problem with Access 2010 where I cannot seem to be able to remove duplicates from a table containing millions of entries midway through a series of queries. The table is formed like this: Date - Serial Number - Reading 1 - Reading 2 - Reading 3 30.7.2013 - 1122334455...
Top Bottom