Group By on Reports Inquiry

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

Bonnie

Using A02 on XP. Used the RptWiz and selected grouping
level and in options selected the max of 10000. I really
want to group by 100,000 not 10,000. So, I edited the
field on the report by adding a zero to each 10000. (Also
put detail Visible to No as I want summaries only.)

From this:
=Int(([PmtAmt])/10000)*10000 & " - " & Int
((([PmtAmt])/10000)+1)*10000
To this:
=Int(([PmtAmt])/100000)*100000 & " - " & Int
((([PmtAmt])/100000)+1)*100000

Now, my rpt shows 100,000 6 times (for each of the
original 10,000 breaks). Is there something else I need to
change somewhere to jump to the 100K breakpoint? What am I
doing wrong?

Thanks in advance for any and all help and advice!!!
 
Sorry folks, I'll answer my own question so no one has to
reply and waste their time.

I forgot to change the Interval on the Grouping level icon.

Duh!!! I knew it was something dumb!
 
Back
Top