Search results

  1. C

    SQL Update syntax

    SQL Update syntax [RESOLVED] Hi Im trying to update a table that has two key fields; ive tried UPDATE tbl SET [val_1]=1,...[val_n]='str' WHERE [key_1]=1,[key_2]=2; But this gives me an error on the WHERE clause. What is the correct syntax? Thanks.
  2. C

    Finding most common number in array

    Hi Anyone have a quick way of finding the most common number in a array? The array is all one dimensional, with variable length, and all integers.
  3. C

    Importing and sorting data from one table to another

    Hi I am pretty green when it comes to ACCESS VBA, ive done some in Excel, but i need some help. I have a data with several records, and these contain data in no particular order. Some of these data need to be modified before being moved to the other database. The code looks like this...
Back
Top Bottom