Reset subtotal within a query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

murch.alexander@gmail.com - 29 May 2008 23:31 GMT

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

Reply to this Message

Bob Quintal - 30 May 2008 11:18 GMT

murch.alexander@gmail.com wrote in
news:70cd767d-4b4d-4ecb-8e19-b14d3ff21299
@f63g2000hsf.googlegroups.co
m:

> Hi all,
>
[quoted text clipped - 11 lines]
>
> Alex

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

Signature

Bob Quintal

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

Reply to this Message

murch.alexander@gmail.com - 30 May 2008 22:10 GMT

> murch.alexan...@gmail.com wrote in
> news:70cd767d-4b4d-4ecb-8e19-b14d3ff21299
[quoted text clipped - 25 lines]
> 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

Reply to this Message