Hi Norm,
I"ve calculated means in Access for datasets having 200,000 records
(rows) and have had no problems. Haven't used Access for larger
datasets; instead i have used MS FoxPro, which is a really good product,
robust and with its own programming front-end.
In my opinion, Access is more like a household database system, since it
has very limited data query facilities. Although it employs SQL to
access records, one cannot do much more processing, unlike in FoxPro
where one can write programs to carry out complicated batch operations.
It all depends on what one needs to do with the data.
I am aware that Excel had some strange bugs, but have not heard the same
about Access. Perhaps you can check in online Access forums.
cheers
amartya
Norm Leonard wrote:
> Does anyone know whether MS Access has (or has had) any of the same
> issues with calculations as MS Excel? Once upon a time, Excel was not
> to be trusted, even when the operation was as simple as calculating a
> mean or standard deviation. Now I am trying to work with a very large
> data set (> 2.5 million records) in Access. I would like to know
> whether this group thinks the means calculated by Access can be
> trusted. Thanks in advance for your comments.
>
> Norm Leonard
> Warnell School of Forestry and Natural Resources
> University of Georgia
> Athens, GA
> [EMAIL PROTECTED]
>
