DoCmd.RunSQL "INSERT INTO te_frais2 (inc,incidentref,contractnumber,NegociatedValueDate,EffectiveValueDate,FlowAmount,FlowCurrency,TDC,PayReceive,facprov,bap,tva,al,CounterpartyRef,ProfitCentercdr,Comments,ProfitcenterBook,vr,Incidentdate,sensfrais,factureref,ProductId,flag) SELECT inc,incidentref,contractnumber,NegociatedValueDate,EffectiveValueDate,FlowAmount,FlowCurrency,TDC,PayReceive,facprov,bap,tva,al,CounterpartyRef,ProfitCentercdr,Comments,ProfitcenterBook,vr,Incidentdate,sensfrais,factureref,ProductId,flag=true FROM te_frais"
voilà, mon pb est qu'il ny' a pas de transfert entre les tables te_frais vers te_frais2 pourtant à mon avis l'insert est bon ,comment çà se fait?
Partager