Recent content by dai_lo

here is the sample data in the attachement

Hi, I have problem convert the following excel formula in to sql code can someone help me? EXCEL (formula for column called MONTH) =IF(OR(G5="LIBOR",G5="FRCOM"),IF(IF(J5="null",I5,J5)<$A$1,1,ROUNDDOWN((IF(J5="null",I5,J5)-$A$1+1)/365*12,0)),-1) please copy the following sample data into...

not all strings contain '|'

SELECT [TDPosting Table_CPG].[Trade Ref], MID([TDPosting Table_CPG].[Trade Ref], 1,INSTR([TDPosting Table_CPG].[Trade Ref], '|')-1)& LEFT([Book Name],7) & [Posting Currency] AS Product, Right([Trade Ref],Len([Trade Ref])-InStrRev([TDPosting Table_CPG].[Trade Ref],'|')) AS [Trade ID], [TDPosting...

sorry, I have no problem with TD_PLDecompLeg_AFS_HEL_ALL_2-27-2009.csv

Hi, I failed importing filename of TD_PLDecompLeg.AFS_HEL_ALL.2-27-2009.csv in both macro and manually but no problem with TD_PLDecompLeg.AFS_HEL_ALL.2-27-2009.csv any idea? thanks alice

Hi, I would like to extract 13743 from a string CNG_AWE SR TRS PAY Bond 7.875 01Mar11 USD - 13Oct05 to 13Oct09|||13-Oct-09|CNG_AWE|13743 a column in a table has a lot of strings like the one above, but they have different length, such as the one below NAB SUB TRS PAY Bond 8.60 19May10...

Hi, I failed to export a text column (such as 00123) from access tabl to excel. In Excel the column turns to 123 please help thanks

Hi, I built a database which consists of many queries. I notice some query object come empty after I executing some queries. anyone know to how prevent this happen? thanks

could you please provide me detail steps to build the forms called Substrates Demand_Supply and tmp_Substrates? I couldn't upload the file because it is over 399KB if you are interested in taking a look of the database, please email me at alice.t.lee@tdsecurities.com thanks

it works.. thanks

Hi, In the Query11, i am comparing two tables' Prod_Str columns and return the Prod_Str record which doesn't exist in tbl_Reconcile_Loans_Breakage_Loans the query11 doesn't do the job as i expect. could you tell me what the problem is.. thanks

Ken, it doesn't work thanks little Al

Hi , I keep getting runtime error 2488 when executing the following code highlighted in Red: Private Sub cmd_Total_Cairo_Per_Month_Click() Dim tostring As Date Dim fromstring As Date fromstring = CDate(Format(InputBox("Please enter from month and year (mmm yyyy)"), "mmm yyyy")) tostring =...

I removed the following Close form event. and it works fine without delete the data. DoCmd.Close acForm, "frm_Create", acSavePrompt any idea? my application allows users to select a record from a list (let's call it RECORD LIST FORM) and then display the selected data in a form (UPDATE...