Envoyé par
jam92400
Bonjour a tous, je suis saturé de Access! j'ai encore une requete qui me pose probleme et qui me genere le type d'erreur "Data type mismatch..."
J'ai deja eu cette erreur et j'avais pallier au pb en modifiant le type de champs en text car visiblement c etait les CDate qu il aimait pas kan j avais un type number a convertir en Date/time
Bref là j'ai encore un soucis mais je vois pas ou cela pe etre apres mainte test alors si qqun pe m eclairer il serai hyper baleze de trouver, j en ai deja epuisé 1 expert qui a pas trop su....:-(
alors HeLP !!
voici la requete:
INSERT INTO BasePamRecon ( PaNum, [Begin], Xbegin, [End], Xend, CpnType, BaseRate, XBaseRate, Rate, XRate, Cur, Xcur, Amount, Xamount )
SELECT DISTINCT
LV1FP901_ICPAM.PADLNO AS PaNum,
CDate([PASTMM] & "/" & [PASTDD] & "/" & [PASTYY]) AS [Begin],
No AS Xbegin,
IIf([cpntype]=70,IIf([PAMTMM]>12,CDate("01" & "/" & "01" & "/" & "2045"),CDate([PAMTMM] & "/" & [PAMTDD] & "/" & [PAMTYY])),
IIf([PAMTMM]>12,CDate("01" & "/" & "01" & "/" & "2045"),CDate([PAENMM] & "/" & [PAENDD] & "/" & [PAENYY]))) AS [End],
No AS Xend,
Chr([CpnType]) AS Expr1,
IIf([CPnTYPE]=86,[VrBase],IIf([cpntype]=65,"ADJ RATE","FIXED RATE")) AS BaseRate,
No AS XBaseRate,
IIf([mhfsttrn].[invmgr]="TR",Val(Left([PABASR],9))+(Val([VrAdjustment])/100),Val(Left([PABASR],9))) AS Rate,
No AS XRate,
LV1FP901_ICPAM.PACCY AS Cur,
No AS Xcur,
Val([PAPAMT]) AS Amount,
No AS Xamount
FROM (((LV1FP901_ICPAM INNER JOIN (mhfsttrn INNER JOIN mhfsisu ON mhfsttrn.Cusip = mhfsisu.Cusip) ON LV1FP901_ICPAM.PADLNO = mhfsttrn.TaNum) INNER JOIN mhfshdr ON mhfsttrn.Portfolio = mhfshdr.Portfolio) INNER JOIN MajorCodes ON mhfsisu.MajorType = MajorCodes.Code) INNER JOIN pmcshflw ON mhfsisu.CashFlowID = pmcshflw.CashFlowID
WHERE (((Right(Left([mhfshdr].[ShortName],1),3) & "000")<>1000) AND ((LV1FP901_ICPAM.PADLST)="PA") AND ((MajorCodes.TranType)="SEC"))
ORDER BY LV1FP901_ICPAM.PADLNO, Val([PAPAMT]);
Et Concernant le format des champs de la table que j'alimente 'BasePam Recon':
Panum: Number
MuNum: Number
Begin: Date/Time
XBegin: Yes/No
End: Date/time
XEnd: Yes/No
CpnType:Text
BaseRate: Text
XBaseRate: Yes/No
Rate:Number
XRate:Yes/No
Cur: Text
XCur:Yes/no
Amout: Number
WAmont: Yes/No
Partager