Search results

  1. C

    SQL Update syntax

    Duh... Thanks, that solved it :)
  2. 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.
  3. C

    Finding most common number in array

    Im looking for the mode, yes. Ive been googling for ages, and the mode did not give any hits. Thanks bob, cyberlynx. This solves it :)
  4. C

    Finding most common number in array

    Thanks All i want is to find the number that repeats most often in the array. The length varies, the array that results from this opperation is disposable. I have a sorted array already.
  5. 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.
  6. C

    Importing and sorting data from one table to another

    Thanks, ken :)
  7. 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