Re: Totals Queries

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

On Wed, 25 Jan 2006 08:47:01 -0800, "MacNut2004"
<MacNut2004@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>How can I get around this?

If there are several values of Rate, which of them do you want to
see???

If there are different rates, you can Group By them (and see one
record for each rate, which makes some sense if the rate contains
meaningful information); or you can use First as the Totals option, to
see an arbitrary choice of one of the rates (concealing the values of
the other rates); or you can uncheck the Show checkbox on the rate if
you only need to use it in calculations.

John W. Vinson[MVP]
.

Relevant Pages