Concatenating Date & Text using Currentdb.execute

[balvinder]

Hi,

I want to append Current_Date_Time before customer_comment field But not able to do so after lot of efforts. e.g.

customer remark is : - I don't want to Pay
Call end time is :- 6/28/2011 8:54:34 PM

Final output should get saved in Customer Comment column is: -

6/28/2011 8:54:34 PM ---I don't want to Pay

Currently i'am using below code & not able to understand how to add this condition in Customer comment.

CurrentDb.Execute "UPDATE Telecalling_database set Calling_end_Date_time = #" & Me.timer1 & "#, Paid_Unpaid_Status = '" & Me.Paid_unpaid_status & "', No_of_Premium_Required = '" & Me.No_of_Prem_required & "', Calling_Code= '" & Me.Calling_Code & "', [COLOR="blue"]Customer_comments= '" & Me.Customer_comments & "'[/COLOR], GO_CODE_Ingenium= '" & Me.GO_Code & "', Modal_Premium= " & Me.Modal_Premium & ", Policy_Paid_To_Date = '" & Me.Policy_paid_to_date & "', MFYP_FRYP= '" & Me.MFYP_FRYP & "', Frequency= '" & Me.Frequency & "', Account_Holder_Name= '" & Me.ACt_Holder_Name & "', Client_Name= '" & Me.Client_Name & "', Account_Number= '" & Me.Account_Number & "', Bank_Name_Ingenium= '" & Me.Bank_Name_Ingenium & "' WHERE Instrument_Number = " & Me.Form_S_No & ""

Please help me in solving this issue.

Thanks in advance ...!!!

 

[Galaxiom]

Why are you saving the date time information twice?
If you want it like that in a report you should concatenate there rather than store it twice. Normally you would just store the CustomerRemark and use this in the textbox.

= CallEndTime & " --- " & CustomerRemark

 

[balvinder]

Thanks a ton...Galaxiom

That worked...!!!

basically My VBA form is designed in such a way, i have to show last call time along with customer comments. Hence i have to club both the things which will be presented in VBA form.


God bless you..!!!