Reset subtotal within a query

[murch.alexander@gmail.com]

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

[Bob Quintal]

Re: Reset subtotal within a query

murch.alexander @gmail.com wrote in
news:70cd767d-4b4d-4ecb-8e19-b14d3ff21299
@f63g2000hsf.go oglegroups.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 from http://www.teranews.com **

[murch.alexander@gmail.com]

Re: Reset subtotal within a query

On May 30, 3:18 am, Bob Quintal <rquin...@sPAmp atico.cawrote:

murch.alexan... @gmail.com wrote in
news:70cd767d-4b4d-4ecb-8e19-b14d3ff21299
@f63g2000hsf.go oglegroups.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.co m**

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