S
sverre
Hi,
I would like to add a few conditions for below query but I dont know how I
write it. Could someone help me:
Rows that have the below combination should not be shown:
Account=1462 and Asset_Liability = L,
Account=1462 and Asset_Liability = L
Account=1462 and Asset_Liability = A
Account=2462 and Asset_Liability = A
The sql looks like this:
SELECT [bokföringen mxg].ACCOUNT, [bokföringen mxg].MX_TRADE_NUMBER,
Sum([bokföringen mxg].AMOUNT) AS SummaförAMOUNT, Sesam.ASSET_LIABILITY,
Sesam.ACQ_ACCRUED_INT, [bokföringen mxg].COMPANY_NUMBER, Sesam.TRN_GROUP,
Sesam.ACQ_AV_NOMINAL, Sesam.ACQ_AV_PREMIUM, Sesam.ACQ_AMORT_PREMIUM
FROM Sesam INNER JOIN [bokföringen mxg] ON Sesam.TRN_NUMBER = [bokföringen
mxg].MX_TRADE_NUMBER
WHERE (((Sesam.LEGAL_ENTITY) Not Like "JK" Or (Sesam.LEGAL_ENTITY) Is Null)
AND ((1)=IIf([ACCOUNT] In (1401,2602,2603,1402,2601,2606) And
[TRN_UNSTARTED]='N',2,1)) AND (([bokföringen mxg].ACCOUNT) Not In
(1040,1042,2440,3000) And ([bokföringen mxg].ACCOUNT)<3000)) OR
(((Sesam.LEGAL_ENTITY) Not Like "JK" Or (Sesam.LEGAL_ENTITY) Is Null) AND
((1)=IIf([ACCOUNT] In (1401,2602,2603,1402,2601,2606) And
[TRN_UNSTARTED]='N',2,1)) AND (([bokföringen mxg].ACCOUNT) Not In
(1040,1042,2440,3000) And ([bokföringen mxg].ACCOUNT)<3000))
GROUP BY [bokföringen mxg].ACCOUNT, [bokföringen mxg].MX_TRADE_NUMBER,
Sesam.ASSET_LIABILITY, Sesam.ACQ_ACCRUED_INT, [bokföringen
mxg].COMPANY_NUMBER, Sesam.TRN_GROUP, Sesam.ACQ_AV_NOMINAL,
Sesam.ACQ_AV_PREMIUM, Sesam.ACQ_AMORT_PREMIUM
HAVING (((Sum([bokföringen mxg].AMOUNT)) Between -10 And 10) AND
(([bokföringen mxg].COMPANY_NUMBER)="8803")) OR (((Sum([bokföringen
mxg].AMOUNT)) Between -10 And 10) AND (([bokföringen
mxg].COMPANY_NUMBER)="8803"));
Best regards
Sverker
I would like to add a few conditions for below query but I dont know how I
write it. Could someone help me:
Rows that have the below combination should not be shown:
Account=1462 and Asset_Liability = L,
Account=1462 and Asset_Liability = L
Account=1462 and Asset_Liability = A
Account=2462 and Asset_Liability = A
The sql looks like this:
SELECT [bokföringen mxg].ACCOUNT, [bokföringen mxg].MX_TRADE_NUMBER,
Sum([bokföringen mxg].AMOUNT) AS SummaförAMOUNT, Sesam.ASSET_LIABILITY,
Sesam.ACQ_ACCRUED_INT, [bokföringen mxg].COMPANY_NUMBER, Sesam.TRN_GROUP,
Sesam.ACQ_AV_NOMINAL, Sesam.ACQ_AV_PREMIUM, Sesam.ACQ_AMORT_PREMIUM
FROM Sesam INNER JOIN [bokföringen mxg] ON Sesam.TRN_NUMBER = [bokföringen
mxg].MX_TRADE_NUMBER
WHERE (((Sesam.LEGAL_ENTITY) Not Like "JK" Or (Sesam.LEGAL_ENTITY) Is Null)
AND ((1)=IIf([ACCOUNT] In (1401,2602,2603,1402,2601,2606) And
[TRN_UNSTARTED]='N',2,1)) AND (([bokföringen mxg].ACCOUNT) Not In
(1040,1042,2440,3000) And ([bokföringen mxg].ACCOUNT)<3000)) OR
(((Sesam.LEGAL_ENTITY) Not Like "JK" Or (Sesam.LEGAL_ENTITY) Is Null) AND
((1)=IIf([ACCOUNT] In (1401,2602,2603,1402,2601,2606) And
[TRN_UNSTARTED]='N',2,1)) AND (([bokföringen mxg].ACCOUNT) Not In
(1040,1042,2440,3000) And ([bokföringen mxg].ACCOUNT)<3000))
GROUP BY [bokföringen mxg].ACCOUNT, [bokföringen mxg].MX_TRADE_NUMBER,
Sesam.ASSET_LIABILITY, Sesam.ACQ_ACCRUED_INT, [bokföringen
mxg].COMPANY_NUMBER, Sesam.TRN_GROUP, Sesam.ACQ_AV_NOMINAL,
Sesam.ACQ_AV_PREMIUM, Sesam.ACQ_AMORT_PREMIUM
HAVING (((Sum([bokföringen mxg].AMOUNT)) Between -10 And 10) AND
(([bokföringen mxg].COMPANY_NUMBER)="8803")) OR (((Sum([bokföringen
mxg].AMOUNT)) Between -10 And 10) AND (([bokföringen
mxg].COMPANY_NUMBER)="8803"));
Best regards
Sverker