No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
5 Posted Topics
Have you adjusted the sp to take account of the additional fields you are inserting? The final error message you have means that there is discrepancy between the parameters you are trying to pass and the parameters defined in the sp definition. Or if you created an amended sp Insert_PublicationsA …
try where datediff(d,O.OrderDate,P.PaymentDate) >=14 --might need to make this 13
Alternatives to first reply - working from memory but tooltips will provide correct spelling and parameters! And other objects Dim sht as Excel.Worksheet Dim rng as Excel.Range 'sheet does not need to be active or visible sht = objWorkbook.Worksheets("Sheet name") rng = sht.Range("A1") rng.value = " some value" rng.Offset(1,10).value="something else" …
How about: UPDATE installment_scheme_customer SET today_date = REPLACE(today_date,'/06/','/04/') WHERE substring(doj_date,4,2)='04'; or alternative where clause WHERE doj_date like '??/04/??' Not done access for a while so I think ? is the correct wildcard for simgle required character! equivalent of sql server '__/04/__'
The End.