Recent content by 12345678

Hi, Soory I was trying to insert excel rows but I didn't manage to. I believe the context of the problem is clear. I have a table of bond prices and the time at which the price was quoted. I want to select only the last price. How can I do this using a query? below are my variables where...

I am receiving undefined function "cdble" in expression

Hi, I have a column of dates in text format (example: 4/15/1994) that I want to format to date numbers (34439 in the example given). Table name is "Issue" column name is "InterestDates". Any help will be appreciated.

I am receiving :undefined function Cdble in expression. I am using office 2007. the query that I ran was: UPDATE 2002 SET [2002].TRD_EXCTN_DT = Cdble(CDate([2002].TRD_EXCTN_DT)), [2002].maturity = Cdble([2002].[maturity]); where 2002 is the name of the table;TRD_EXCTN_DT is the text column and...

the format is dd/mm/yyyy in both columns for example 18/02/1999 but the datatype for one column is text and for the other is date/time. I want to obrain a date number such as 36209 (which corresponds to 18th of February 1999)

Hi, I have a huge database where each column consists of millions of observations. one column is a column of dates but in text format (Dates1 column) and the second column is a column of dates but in a date/time format (Dates2 column). First I tried to have them in the same format by changing...

How can I fill the empty cells in a table with a number , for example "-999" or text, such as" na".