group suppression

  • Thread starter Thread starter mcnewsxp
  • Start date Start date
M

mcnewsxp

how to do group suppression on a report ala:

99999 XXXXXXXXXX 999 999 999
999 999 999
99999 XXXXXXXXXX 999 999 999
99999 XXXXXXXXXX 999 999 999
999 999 999
999 999 999
 
Not sure what you mean by "group suppression", and that's really not
much of a description of what you need.
I'll assume you mean that you don't want to repeat the 99999 XXXXXXXXX
after the first line in each group?

Set the two control's Hide Duplicates property to Yes.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
A couple of minor points...
You asked this same question in the Getting Started newsgroup and it was
answered successfully by John Vinson.
(the same suggestion as mine)

If you must post the same question to more than one group, include both
newsgroups in the Newsgroup section of post.
(ex. microsoft.public.access.reports ;
microsoft.public.access.gettingstarted)
Any responses in one group will be seen in the others. This prevents
duplication of effort , answering a question that has already been handled
successfully.
See... http://www.mvps.org/access/netiquette.htm under multi-posting.
group suppression is what they called when i went to school....
Click to expand...
That may be so, but that terminology is incorrect.

And... it wouldn't hurt to say thanks when someone tries to help you...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top