Search results

  1. G

    LIKE '%' doesn't take into account NULL values

    Hi all, I have a select statement liek this one: Select * from table1 where lastname LIKE 'var1%' and firstname LIKE 'var2%' and address LIKE '%' My problem is that the select will not return those records where address is null! Is there any way to overcome this without converting all the...
  2. G

    copy the values from one record to another

    Hi, I have a table and want to copy the values from one record to another. For instance I want to copy all the values from record with ID 100 to record with ID 110. Why would I want something like that? Because a user mistakenly placed the record at 100 instead of 110. Then the 100th record...
  3. G

    how to return the autoincrement number from corresponding insert

    Hi all (and Merry Christmas). I have an insert query. When the user clicks save, I want the insert statement to return the number from the ID field of the table which is autoincrement (and is auto completed by the database). The problem is that the database sits on a server and many users use...
  4. G

    table column alignment problem

    Hi, I have a table that was inserted from excell. The problem is that some columns appear left justified and some right justified, while I want all to be left justified. if i try to write something on a column that appears as right justified the cusror starts from the right. The same applies...
  5. G

    Update... table1.column=table2.column where table1.id=table2.number

    Hi all, I want to update the columns of one table to the columns of another table based on a common field. This is what I tried but it's not working: UPDATE TABLE1 SET TABLE1.NAME = TABLE2.NAME WHERE TABLE1.ID=TABLE2.CARD_NUMBER (ID and card number are unique, card numbers is a subset of id...
  6. G

    Many clients - increment by1 field problem

    Hi all, One of the columns in my database is a protocol number. This number has to increment by 1 each time there is a new entry, and has to be unique. The problem is that this database has already protocol values and is accessed by many clients. So just finding the last protocol and...
  7. G

    Problem with importing excell file to access

    Hi Guys, Sorry for posting also here and to excell but it's related. When I try to import an excell sheet that has dates in the form 19/9/03 to access, I get type conversion failure. If the date is 19/09/03 then it works fine. I have also one other column with numbers. If there is space between...
Back
Top Bottom