Search results for query: *

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...

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...

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...

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...

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

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

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

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...

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

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?

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

WoooooW . it works. thx

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...

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...

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

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

yes. :) Sql microsoft access

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

nope. still syntax error

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