Reset subtotal within a query

Hi all,

I have a query that uses a subquery to subtotal one of its fields.
This part is working fine. The twist is that when I encounter certain
values, I want to reset the subtotal to zero and continue on. So, it's
possible that out of 100 records, I might reset the subtotal to zero
20 times.

I can do this in a report but I need it in query form so I can run it
automatically when users log in to let them know if the subtotal has
reset. Any suggestions would be greatly appreciated.

Thanks,

Alex
.

Relevant Pages

  • RE: Need help with a query
    ... but i don't know how to write the criteria to set the ... I would like to reset the count to 0 (ZERO) when a yes is found, ... Is this possible for a query. ...
    (microsoft.public.access.gettingstarted)
  • Re: Conditional printing of records in the detail section of a rep
    ... I got sick, still sick, so I'm putting this on hold for the moment. ... In query design, type an expression like ... sums the numbers from approximately 35 numerical fields ... The default data is zero. ...
    (microsoft.public.access.reports)
  • Re: Gottleib EM - 1976 Surf Champ
    ... Well, If I power on and the reels are not at zero, it will sometimes go ... through the reset and reset them to zero... ... When I press any of the scoring relays, the relays at the top-rear of the ... Adjusting newer GTB interlock relays,, ...
    (rec.games.pinball)
  • Re: Conditional printing of records in the detail section of a rep
    ... The query option, as outlined in your post, doesn't work. ... The default data is zero. ... commands used in the Event Procedure? ... unbound form with a command button to open the report filtered, ...
    (microsoft.public.access.reports)
  • Re: Does DateDiff Have A Bug
    ... a calculated field in a query is the way to go here. ... But here's why I added the DaysRemaining ... I'm trying to write the result of lngDays when it reaches zero days ...
    (microsoft.public.access.formscoding)