running total problem - non unique date

Hi,
I am trying to get access 97 to do a running total query without much success.
I posted an earlier question on the subject, but the solution still did not
work:

http://support.microsoft.com/newsgroups/?dg=microsoft.public.access.queries&mid=e7241392-bd9d-4d78-9fce-4349995d05cf&sloc=en-us&sloc=en-us

I believe the problem is that i am trying to calculate a running total field
ordered by date, but there is more than one value for activity for each date.
This is the result that i need :

Date Activity running total of activity
12/02/04 5 5
13/02/04 6 11
13/02/04 3 14
13/02/04 11 25
21/03/04 1 26
etc.
Please could someone advise me of the best way to achieve this?
Thanks,
Ed.
.

Relevant Pages

  • Re: running total problem - non unique date
    ... >I am trying to get access 97 to do a running total query without much success. ... You could use the Date/Time ) rather than the date, ...
    (microsoft.public.access.queries)
  • Re: Calling a method
    ... If a book about failures doesn't sell, is it a success? ... Prev by Date: ...
    (comp.lang.java.help)
  • Re: How to get top-level site collections names programmatically
    ... > The collection of SPSites returned by the SPVirtualServer object ... > I've looked around for it, without success. ... Prev by Date: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Format conversion from number to YYYYMM
    ... calculate previous month\ prev 3 months etc, I need to convert this to ... date format yyyymm. ... I have tried but with no success, I would be thankful for help. ... compelled to cast themselves into the sea to their destruction. ...
    (comp.databases.ms-access)
  • Re: Regedit last key
    ... > There are two secrets to success in life ... Prev by Date: ...
    (microsoft.public.windowsxp.general)