Advance Query..Urgent

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

Arijit Chatterjee wrote:[color=blue]
> 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[/color]

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.

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

Arijit Chatterjee wrote:[color=blue]
> 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[/color]


No, there is not.