S
sverre
Hi
I have the following query:
SELECT 1402 AS ACCOUNT, [YY Saldo 1402].SummaförAMOUNT AS HB, [YY Saldo
1402].ACQ_AV_ACCRUED_INT AS SESAM, [HB]-[SESAM] AS [Diff HB SESAM]
FROM [YY Saldo 1402]
GROUP BY 1402, [YY Saldo 1402].SummaförAMOUNT, [YY Saldo
1402].ACQ_AV_ACCRUED_INT, [HB]-[SESAM];
What I would like to add is to use the function sum for the fields:
1. SummaförAMOUNT (renamed to HB)
2. ACQ_AV_ACCRUED_INT AS SESAM (renamed to SESAM)
3. Diff HB SESAM
When I use the function SUM instead of group by on these fields ACCESS
returns a 3 Boxes and asks me for parameter value for each field.
Can I avoid this and why does Access ask for parameter value?
Many thanks in advance
I have the following query:
SELECT 1402 AS ACCOUNT, [YY Saldo 1402].SummaförAMOUNT AS HB, [YY Saldo
1402].ACQ_AV_ACCRUED_INT AS SESAM, [HB]-[SESAM] AS [Diff HB SESAM]
FROM [YY Saldo 1402]
GROUP BY 1402, [YY Saldo 1402].SummaförAMOUNT, [YY Saldo
1402].ACQ_AV_ACCRUED_INT, [HB]-[SESAM];
What I would like to add is to use the function sum for the fields:
1. SummaförAMOUNT (renamed to HB)
2. ACQ_AV_ACCRUED_INT AS SESAM (renamed to SESAM)
3. Diff HB SESAM
When I use the function SUM instead of group by on these fields ACCESS
returns a 3 Boxes and asks me for parameter value for each field.
Can I avoid this and why does Access ask for parameter value?
Many thanks in advance