efficiency2

[The Dummy in Access for Dummies]

Is it better to have all of the calculations in one calculated query or
should I have create a calculated query for each calculation? Query table; I
mean like having the sum of a series of fields and the standard deviation of
the same series of fields in the same query design? (keep in mind that this
is just a simple example, I actually have quite a number of calculations)

 

[John Vinson]

Is it better to have all of the calculations in one calculated query or
should I have create a calculated query for each calculation? Query table; I
mean like having the sum of a series of fields and the standard deviation of
the same series of fields in the same query design? (keep in mind that this
is just a simple example, I actually have quite a number of calculations)

Asking the same question five times will not get you a faster answer,
or more answers. Maybe you're not familiar with Newsgroups (despite
Microsoft's webpage interface, this *is* a newsgroup).

The only answer to your question has to be "that depends". If you'll
be routinely opening this Grand Master Query but only using one or two
calculated fields, then no, it's not a good idea - you'll have to do
all the calculations, even if you're ignoring most of them. If you
will instead be routinely generating reports using most or all of the
calculations, then by all means, get them all done in one operation.

Since nobody volunteering here knows the nature of the calculations or
how they will be used, I can't imagine that we could give you a
definitive answer!

John W. Vinson[MVP]