Re: Reset subtotal within a query

On May 30, 3:18 am, Bob Quintal <rquin...@xxxxxxxxxxxxx> wrote:
murch.alexan...@xxxxxxxxx wrote in
news:70cd767d-4b4d-4ecb-8e19-b14d3ff21299
@f63g2000hsf.googlegroups.co
m:



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

present the report in preview mode to the users, by puttong an
openreport statement in the autoexec macro or in your startup form.

--
Bob Quintal

PA is y I've altered my email address.
** Posted fromhttp://www.teranews.com**

Good thought, but... this query is a stepping stone in a series of
queries. The report works, but I need the data in query form so I can
spin other queries off of it.

-Alex
.

Relevant Pages

  • 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: Making sure you receive it all
    ... And you should not reset it to zero, ... I presume also then that i have to keep appending ... catch(SocketException exc) ...
    (microsoft.public.win32.programmer.networks)
  • Re: Bally EM Score Reset issue: What the heck is going on???
    ... player's score reels won't reset to zero... ... Score Reset 2, pulse score motor switches, and score reel 0 position ... So when I play a 1 player game, sometimes all score reels go to zero, ...
    (rec.games.pinball)
  • Re: Bally EM Score Reset issue: What the heck is going on???
    ... player's score reels won't reset to zero... ... Score Reset 2, pulse score motor switches, and score reel 0 position ... So when I play a 1 player game, sometimes all score reels go to zero, ...
    (rec.games.pinball)
  • Bally EM Score Reset issue: What the heck is going on???
    ... player's score reels won't reset to zero... ... Score Reset 2, pulse score motor switches, and score reel 0 position ... So when I play a 1 player game, sometimes all score reels go to zero, ...
    (rec.games.pinball)