Advance Query..Urgent

[Arijit Chatterjee]

Dear All,
I have written a query in Oracle.It is actually doing a running sum
for a particular field.I am giving the query details
================================================== ===========
select
accountcode,
datefield,
voucherkey,
drcr,
amount,
sum(decode(drcr,1,amount,amount*(-1))) over
(partition by accountcode order by datefield, voucherkey) as RunnigSum
from Accounts
================================================== ===========
But I need the equivalent query in MS Access.But I didn't get the feature
"partition by".Please advice me how to move..
Regards
Arijit Chatterjee

[Bruce Dodds]

Arijit Chatterjee wrote:

Dear All,
I have written a query in Oracle.It is actually doing a running sum
for a particular field.I am giving the query details
================================================== ===========
select
accountcode,
datefield,
voucherkey,
drcr,
amount,
sum(decode(drcr,1,amount,amount*(-1))) over
(partition by accountcode order by datefield, voucherkey) as RunnigSum
from Accounts
================================================== ===========
But I need the equivalent query in MS Access.But I didn't get the feature
"partition by".Please advice me how to move..
Regards
Arijit Chatterjee

Look up "crosstab queries" in Help to get the Access SQl equivalent to
"partition by".

I don't believe it's possible to do running totals in queries, though
you can do them in reports via the RunningSum text box property.

[Arijit Chatterjee]

Thanks for the response.But I don't need the "Cross Tab" output.Can
anyone tell me what the substitute of Trigger in MS Access.If I am
inserting some data to a particular table.Is there any way to identify
that from database end.
Regards
Arijit Chatterjee

[Bruce Dodds]

Arijit Chatterjee wrote:

Thanks for the response.But I don't need the "Cross Tab" output.Can
anyone tell me what the substitute of Trigger in MS Access.If I am
inserting some data to a particular table.Is there any way to identify
that from database end.
Regards
Arijit Chatterjee

No, there is not.