Query Add-in for Autonumbers and Running Sums
NOW WITH ACCESS XP (2002) VERSION
The link below is an add-in wizard which will help you to build any
query that needs an autonumber generated within it, a running sum query, a
running average query or a moving average query. This wizard uses sub select SQL
rather than Domain functions which can be very slow for large recordsets. Please
be aware that even sub select queries are slow with large recordsets, but they
are accepted to be the fastest way of achieving these goals. You may also find
that looping through the recordset in code to create the desired result will get
you there faster.
Download the link below and save it anywhere. Open access and open
any existing database you have. From the tools menu choose add-ins add-in
manager. Choose add new and browse to the location you saved the downloaded file
and double click on it. Close the add-in manager. Open the database you need to
create the query in. Go to the queries tab and click new. You will see the new
wizard listed in the options as Running Total Query. Click on it and click OK.
Follow the onscreen instructions. Please note the query will not
let you continue until you have selected the requested information.
This is version 1.2.0 of this add-in. If you would like to be
informed of updates or have a suggestion for the next version contact Email Help
This is a free add-in. If you have found it so useful you feel
obliged to send money then
use the Donate link. This will
help the development of new add-ins.
You are free
to use this add-in for your personal use, however commercial use and
distribution is strictly prohibited. If you wish to distribute commercially or
use this add-in within a commercial environment please use the following form Email Webmaster
PLEASE NOTE I HAVEN'T BEEN ABLE TO GET THIS TO WORK WITH ACCESS 2000.
QueryCreator.mda FOR ACCESS 97
QueryCreatorXP.zip FOR ACCESS XP (2002)
1.2.0 Corrected the problem with not being able to handle huge numbers of
1.1.0 Test in house version Not Released
1.0.0 First Release.