| re: Advance Query..Urgent
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. |