Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. wdbouk

    Linking two columns

    Hi, In one table I have a 6 digit number(called cusip) that refers to bonds traded in the USA. In another table I have the cusip of these bonds as reported by another database, however the format of the cusip in the other database is not 6 digits. sometimes it is 3 sometimes 4 sometimes 5 and...
  2. wdbouk

    Basic question-selecting cells

    most probably u misunderstood my question or I misunderstood ur answer. pointing to sheet1 would oblige me to do it for every cell in sheet2 since the values of sheet 2 oblige me to select an observation from every 10 observations in sheet 1. I am simply wondering if I could make sheet2 cells...
  3. wdbouk

    Basic question-selecting cells

    Hi, in sheet 2 , I am selecting cells of sheet 1 that are incremental by 10, for example Sheet2!A1 should have the value of Sheet1!A3, Sheet2!A2 should have the value of Sheet1!A13, Sheet2!A3 should have the value Sheet1!A23 etc... I am wondering how to do it (the data is large) by writing a...
  4. wdbouk

    separating numbers from letters

    Hi, I have a column where the content is a mix of numbers followd by letters. such as 025816AK (always numbers followd by letters but the length of numbers and letters differ and not always 6 numbers to 2 letters).I am wondering if there is a way to let Access separate the numbers from letters...
  5. wdbouk

    Assigning a unique number to a unique text

    I looked at the all options available and i wasn't able to locate the Autocolumn. is it ok if i asked u to elaborate in this matter? thx
  6. wdbouk

    Assigning a unique number to a unique text

    Hi , I have a 1,500,000 ID such as 6543AE , 6543AF, 456AV etc.... I am looking for the unique IDs in order to assign them a unique number in a new column such as 1 for 6543AE, 2 for 6543AF, 3 for 456AV. is it possible to do so using Access? Thx W
  7. wdbouk

    Matching two text columns

    nope. the same problem. all observations from Prices2 are reported and none of the selected table
  8. wdbouk

    Matching two text columns

    Actually it is not working. it is returning all the values of tableA.cusip without matching the tableB.cusip the query is: SELECT Prices2.Cusip, Prices2.Date, Prices2.Price, Prices2.Accrued, Prices2.Yield, Prices2.Duration, Prices2.Convexity, Selected.* FROM Prices2 LEFT JOIN Selected ON...
  9. wdbouk

    Matching two text columns

    yes tick marks ' and " are in the field value. Thanks belovedcej ur method works
  10. wdbouk

    Matching two text columns

    could u clarify more? I am receiving errors with my interpretations. assume i have table A qand table B . how to compare A.cusip with B.Cusip?
  11. wdbouk

    Matching two text columns

    Hello, I have two text columns but for some reason one of them has the following format " 1234AAT' and the other 1234AAT. When I try to match them I receive 0 match. I am wondering how to get rid of the "" and ' in the " 1234AAT' format or how to match the two text columns? Thx
  12. wdbouk

    error in conversion

    WoooooW . it works. thx
  13. wdbouk

    error in conversion

    I tried all the number formats (byes, single, ling integer etcc) the only format that worket was replication ID and this format can't be read in matlab where i tend to extract my data. the CInt returned more conversion errors than before. any helo about the fval or if thge replication ID could...
  14. wdbouk

    error in conversion

    I have a column full of numbers but in text format. I tried converting the column from text to number but i lost a lot of observations by doing so (error message). I am sure that all of the observations are numbers. it used to be 6 numbers + 3 letters and I updated the column to remove the...
  15. wdbouk

    error converting the data

    sorry for the inconvinience. i will post the same thread in 701
  16. wdbouk

    error converting the data

    sorry for that. i am not very familiar with Access and simply trying to organize the data and export it to matlab :)
  17. wdbouk

    error converting the data

    yes. :) Sql microsoft access
  18. wdbouk

    error converting the data

    sybtax error (missing operator)in query expression 'cast (cusip as numeric)'
  19. wdbouk

    error converting the data

    nope. still syntax error
  20. wdbouk

    error converting the data

    there is a syntax error in the UPDATE All SET Field1=cast(Cusip as numeric) expression. i tried many changes without success.

Part and Inventory Search

Back
Top