Search results

  1. O

    Update Querry

    I have these three tables A, B, C and D. IN table A, SSN is the primary key. Tables B, C, and D have other columns, but the also have SSN as one of the columns. Also SSN is NOT required in other tables. What I need to do is to be able to run an update querry that will update the value of the...
  2. O

    Selecting qith no Duplicates

    Hey, I have a table with columns A,B and C. Column A may has a value that may be duplicated. eg A B c 1 2 3 1 5 8 7 5 4 5 6 8 I need a querry that will only return the 8 unique numbers, instead of 12, which is infact the total number of entries!
  3. O

    Commenting out SQL Codes in Access

    Hello, I was wondering, is there a way to comment out some of your SQL codes in Access querries, like you do in Oracle or SQL Server or VB? I need to know how to write comments in my SQL codes when usingh access
  4. O

    Update Query

    I have three columns TU, EFX, XPN a fourth column FICO which is based on the values in TU, EX and XPN. I need to update the FICO column so that it is either MEDIAN of TU, EFX, XPN or Minimum of TU, EFX Minimum of TU,XPN, Minimum of XPN, EFX I expected the SQL statement to be something like...
  5. O

    Updating fields in Access Table Using data from Excel

    Hello, Been wondering how I can update fields in my Access database table using data that lies in an excel spreadsheet. They have a common row ie say account number and other common fields that need to be updated. thanks
  6. O

    Restoring an Access database

    Hello, Is there anyway possible to restore a database to a former state? what happens is that I updated some information unknowingly, now I get into my database, and I cant find some data, which I suppose i updated probably the last time I worked on a the table. Any clues on how to handle this?
  7. O

    Importing an Excel Spreadsheet

    Hello Peeps, I'm trying to import an excel spreadsheet into an access table. The excell spreadsheet was created using the access table( by using the 'analyze using excel' feature) The problem is that I cannot import the updated excell spreadsheet. I get the error message.." An error occured...
  8. O

    Update Querry

    Hello, This may sound too common a question, but I really need help on it. Prior querries in the same do not seem to solve it. I have two tables, table1 and table2 with the following fields table1 ( ACID, name, address, Salary, MStatus,Age) table2 ( ACID,salary, Age) ACID is the common field...
  9. O

    Update Table Querry

    I have a table in access. The columns are State, FICO, LTV, DTO,LBI and Grade need to update the column (Grade) so that it gets the values A, B, C or D based on the following conditions If FICO >525 and LTV <100 AND DTI <50 then grade = D IF FICO >600 AND LTV BTWN 90 -100 AND DTI <50 Grade =c...
Top Bottom