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

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

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

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

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

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

Hi, i am wondering how to update columns with dates like 8/20/1991 to date number like 33470 thx

Hello, I want to append more than 100 tables at the same time . is it possible? they all have a column named "Trader/Matrix" so I want to SET "Trader/Matrix" =1 WHERE "Trader/Matrix"="Q". i want to do the same thing for many column but let us start with one column . if this could be made it...

Hello, I have 2 columns. one for dates and the other for stock tickers. I want only the first date for the stocks with the similar ticker. How can i do so? thx

I am trying to use the IIF statement to assign new values for a table using the following command UPDATE [All] SET Field17 = IIf ([Field2]="AC.DB0",151100); it is working fine but if i want to use it to assign another value [Field2]="AZG.DB0",9800);then the previous 151100 values assigned in the...

Hi, I have a column with only two text letters Q and M. I want to create a new column where for the values Q I want to assign number 1 in the new column and for M I want to assign number 2. In Excel it is easy (=if a1="Q",1,2) asuming the cell is a1 in the column containing Q and M values. Is...

Hi , I know that this question could be a basic one. But how can i delete the duplicates from my data. For example if I have 5 duplicate rows how can I tell access to eliminate 4 of them and keep the 5th. Thx

Hello, I have a text field with 9 characters and i want to select only the first 8 of it. I tried the following UPDATE ISSUE SET Cusip8 =(Cusip9,8);but i received a syntax error. Any other suggestion? thx

Hello, I have the following querry : SELECT Prices.*, ISSUE.* FROM Prices LEFT JOIN ISSUE ON LEFT(Prices.Cusip,8)=LEFT(ISSUE.Cusip9,8); when i run it , i see the result. However,when i want to modify it to a make table query i receive an error that access can't represent the join expression...

Hi all, I am wondering how to calculate the absolute values in access. I have a huge database and I want to transform negative number to positive ones. Thanks

I am wondering if I have a column of dates that I want to transfer to numbers (like excel) is it possible to so with access. My file is large and I can't transfer to excel to do the date conversion. Thx

I was trying to convert text dates to date type and I am losing all the records. what is the appropriate way to do it? Thx

Hi all, I will start with an example: I have a column A consisting of ID numbers . I want to count the number of times each ID number is mentioned. For example ID ABC ABC XYZ a123 a123 a123 then ABC should =2,XYZ=1,a123=3. Any help of how to do it? thx

Hello, I have two columns one with 9 character and the other with 8. I want to match the two columns where the first 8 characters of both matched. I used the following: SELECT FinancialQ.*, IssueM.* FROM FinancialQ LEFT JOIN IssueM ON FinancialQ.Cusip = IssueM.Expr1000 WHERE ON LEFT( FinancialQ...