I am an Access Novice...

I have a database of 100,000.00 records. Can Access select a sample from
this dataset that will enable me to perform lognormal statistical analysis ?

What sql can I use to selest the sample data ?

Thank you in advance.

I'm not sure that Access has any built-in functionality that will help with
lognormal statistical analysis. You might want to take a look at Total
Access Statistics, from FMS Inc.
http://www.fmsinc.com/products/statistics/index.html

For how to construct a query that returns a random set of records, take a
look at http://www.mvps.org/access/queries/qry0011.htm at "The Access Web"

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"carl" <(E-Mail Removed)> wrote in message
news:BB92879D-E777-4B7B-93B2-(E-Mail Removed)...
>I am an Access Novice...
>
> I have a database of 100,000.00 records. Can Access select a sample from
> this dataset that will enable me to perform lognormal statistical analysis
> ?
>
> What sql can I use to selest the sample data ?
>
> Thank you in advance.

if you were to use Access Data Projects; keep your data in SQL Server--
then you could use 'Analysis Services'

SSAS has some GREAT statistical functions

MDB is for lamers

-Susie


Douglas J. Steele wrote:
> I'm not sure that Access has any built-in functionality that will help with
> lognormal statistical analysis. You might want to take a look at Total
> Access Statistics, from FMS Inc.
> http://www.fmsinc.com/products/statistics/index.html
>
> For how to construct a query that returns a random set of records, take a
> look at http://www.mvps.org/access/queries/qry0011.htm at "The Access Web"
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "carl" <(E-Mail Removed)> wrote in message
> news:BB92879D-E777-4B7B-93B2-(E-Mail Removed)...
> >I am an Access Novice...
> >
> > I have a database of 100,000.00 records. Can Access select a sample from
> > this dataset that will enable me to perform lognormal statistical analysis
> > ?
> >
> > What sql can I use to selest the sample data ?
> >
> > Thank you in advance.

Susie;

Analysis Services is hard for beginners-- but the best route to go.

Do you have any resources for Doug?

-Tom


(E-Mail Removed) wrote:
> if you were to use Access Data Projects; keep your data in SQL Server--
> then you could use 'Analysis Services'
>
> SSAS has some GREAT statistical functions
>
> MDB is for lamers
>
> -Susie
>
>
> Douglas J. Steele wrote:
> > I'm not sure that Access has any built-in functionality that will help with
> > lognormal statistical analysis. You might want to take a look at Total
> > Access Statistics, from FMS Inc.
> > http://www.fmsinc.com/products/statistics/index.html
> >
> > For how to construct a query that returns a random set of records, take a
> > look at http://www.mvps.org/access/queries/qry0011.htm at "The Access Web"
> >
> > --
> > Doug Steele, Microsoft Access MVP
> > http://I.Am/DougSteele
> > (no private e-mails, please)
> >
> >
> > "carl" <(E-Mail Removed)> wrote in message
> > news:BB92879D-E777-4B7B-93B2-(E-Mail Removed)...
> > >I am an Access Novice...
> > >
> > > I have a database of 100,000.00 records. Can Access select a sample from
> > > this dataset that will enable me to perform lognormal statistical analysis
> > > ?
> > >
> > > What sql can I use to selest the sample data ?
> > >
> > > Thank you in advance.

ah, my favorite, a .00 records statistician. I love precision. (:-<)

you can obtain a random selection of records using WHERE RND([yourfield])
> .whatever
you have to use a dummy positive field to ensure that the RND function gets
called for each record, or sort the table on RND([yourfield]) and select TOP
N.


"carl" <(E-Mail Removed)> wrote in message
news:BB92879D-E777-4B7B-93B2-(E-Mail Removed)...
>I am an Access Novice...
>
> I have a database of 100,000.00 records. Can Access select a sample from
> this dataset that will enable me to perform lognormal statistical analysis
> ?
>
> What sql can I use to selest the sample data ?
>
> Thank you in advance.
>