Totals Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a report that is based on an underlying totals query. I am trying to
stick a field from one of the tables joined in that query in the grid - it is
a Rate field. However, for it to show up, it either has to be a sum (makes
no sense since it's a rate) or a group by, which i don't want.

How can I get around this?

Thank you!
MN
 
Because when I do that, I have a a lot more records being displayed - 134
compared to the original 52. It seems to be dividing up the previously
summed amounts of each. How do I get around that then?

Thanks,
MN
 
How can I get around this?
Click to expand...

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]
 
John,

Thank you for the insight. There are several different rates and they are
all meaningful. I never heard of using "first" in the totals query....I put
that in there and noticed that the record count is back to 52...but that only
contains the FIRST rate for that record....I understand what you are saying.
So I guess I want to use the group by feature since I need to see every
rate...

Thanks,
MN
 
John,

Thank you for the insight. There are several different rates and they are
all meaningful. I never heard of using "first" in the totals query....I put
that in there and noticed that the record count is back to 52...but that only
contains the FIRST rate for that record....I understand what you are saying.
So I guess I want to use the group by feature since I need to see every
rate...
Click to expand...

If you want to see all the rates in one record, you can use some VBA
code to extract them and concatenate them into one string:

http://www.mvps.org/access/modules/mdl0008.htm

John W. Vinson[MVP]
 
Back
Top