Re: Loop in button code

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Thu, 16 Apr 2009 07:45:01 -0700, Kevin199
<Kevin199@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

A little more detail of my original post may be in order. I want the loop to
go through my YG table and compare sales volumes of inventory items from
various retail sites and calculate a correlation from each location compared
to the rest of the location combined. In the past I have done the
calculation in excel. I have now been given the project to go back into
historical data and run hundreds of these calculations, thus my motivation.
I thought that once I got a loop to work off my button on a form I could
start putting in code to get the rest to work. Right know I have 4 sub
queries that pull data out of my table and calculate the correlation of one
location compared to the others. I am planning on using them in some form in
my loop.

I still don't see how the OpenQuery method is of use here. This would not
calculate any correlations; it would just open a blizzard of datasheets which
the user would have to look at and close one at a time.

--

John W. Vinson [MVP]
.

Relevant Pages

  • Re: An idea for a csprng with integers.
    ... Or 28 bytes per loop, ... os woefully inadequate even as a non-cryptgraphic PRNG, ... correlation between btytes. ... More correlation tests gave the expected values. ...
    (sci.crypt)
  • Re: huge microarray coexpression matrix (25K genes)
    ... x 25K which my 2 gb of ram is not able to handle. ... You can compute the correlation coefficient in a loop, ... cnt = cnt + 1; ...
    (comp.soft-sys.matlab)
  • Re: An idea for a csprng with integers.
    ... Or 28 bytes per loop, ... IF however you ouput the values on each loop, ... correlation between btytes. ... More correlation tests gave the expected values. ...
    (sci.crypt)
  • Re: Loop in button code
    ... I may try to change to only a query ... and no loop at some point, but you know how that is. ... That will loop through each record of a recordset. ... something else that deals with each site and its correlation. ...
    (microsoft.public.access.modulesdaovba)
  • ksdensity returns inf
    ... I do a rather large expample with correlation between more than 100 vectors. ... At first I typically loop over ksdensity, X, 'function', 'cdf'); since each vector in X is not distributed exactly the same way ... Hints or tips? ...
    (comp.soft-sys.matlab)