ACCESS FEED: Re: [MS_AccessPros] Help with grouping on a report

Selasa, 17 September 2013

Re: [MS_AccessPros] Help with grouping on a report

Thanks Graham. I will try to see which one of your suggestions below works best for me.

Toukey

--- In MS_Access_Professionals@yahoogroups.com, "Graham Mandeno" <graham@...> wrote:
>
> Hi Toukey
>
> You could do this by writing code for the Format event of your Detail
> section which "remembers" the previous invoice number and makes the name
> textbox visible only if the current invoice is different.
>
> However, I think your report would look better and be easier to read if you
> add a group header for the invoice number sort level, and move the name and
> invoice number into the group header section. The formatting will probably
> not look good in this forum, but something like this:
>
> John Doe Inv. # 200
> pkg ctn lbs dimension
> 1 1 10x10x12
> 1 2 12x10x9
> 1 5 9x18x5
>
> John Doe Inv. # 400
> pkg ctn lbs dimension
> 1 3 12x10x12
>
> Best wishes,
> Graham
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of toukey1
> Sent: Tuesday, 17 September 2013 16:02
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Help with grouping on a report
>
>
> Ok - just when I thought I had it another scenario presents itself. I would
> like to hide the duplicates where the Inv.# is the same. i.e. I would like
> the name appearing more than once on the report when the Inv. # is
> different. Somewhat simlar to below.
>
> Name pkg ctn lbs dimension Inv. #
> John Doe 1 1 10x10x12 200
> 1 2 12x10x9
> 1 5 9x18x5
> John Doe 1 3 12x10x12 400
>
> Appreciate your assistance again.
>
> Regards
> Toukey
>
> --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@>
> wrote:
> >
> > Toukey-
> >
> > Set the Hide Duplicates property of the Name control to Yes.
> >
> > John Viescas, Author
> > Microsoft Access 2010 Inside Out
> > Microsoft Access 2007 Inside Out
> > Microsoft Access 2003 Inside Out
> > Building Microsoft Access Applications
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of toukey1
> > Sent: Sunday, September 15, 2013 6:00 AM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Help with grouping on a report
> >
> > Hi,
> >
> > I am trying to produce a report (based on a query) which currently shows
> the
> > following:
> >
> > Name pkg ctn lbs dimension
> > John Doe 1 1 10x10x12
> > John Doe 1 2 12x10x9
> > John Doe 1 5 9x18x5
> >
> > How can I get it to display where the Name is not repeated like this:
> >
> > Name pkg ctn lbs dimension
> > John Doe 1 1 10x10x12
> > 1 2 12x10x9
> > 1 5 9x18x5
> >
> > Thanks for your assistance in advance.
> >
> > Toukey
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>