Re: Reset subtotal within a query

murch.alexander@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 from http://www.teranews.com **
.

Relevant Pages

  • Re: Can foreground and background colors be queried?
    ... query the currently set colors ... When exiting, reset the colors back to what they were ... set so I can read without eyestrain and I'm very comfortable with ...
    (comp.lang.rexx)
  • RE: Number Sequence on Table
    ... In order to reset the counter to zero, ... Then, in your insert query add a computed column that calls the function, ... Static mySeqNo As Long ... Currently I am deleting the contents the table- then condencing the file- ...
    (microsoft.public.access.modulesdaovba)
  • Re: Rolling Differences
    ... is one in what I wrote) which references the outer query (which I did have ... "Previous Inventory" value: ... I mentioned the question of "groups" which may reset your totals. ...
    (microsoft.public.access.queries)
  • Re: Creating an autonumber ID field in a make table query?
    ... I created a query to delete all the records then ran it then the other queries in a macro. ... "Jeff Boyce" wrote in message ... That said, if you absolutely, positively must reset autonumbers, do a search on "reset autonumber"... ... I link access to our oracle database through ODBC and download the data for a particular station and then crunch the data. ...
    (microsoft.public.access.queries)
  • Re: Filter list box by text box
    ... Edward H via AccessMonster.com wrote: ... >I have a query form. ... The form have many text boxes. ... >linked to a query that displays all entries in my table. ...
    (microsoft.public.access.formscoding)