Hi,
Just when I thought I had this working correctly, another scenario presents itself. In the first scenario below, I wanted to remove the name when duplicated. Now in this scenario I want to be able to remove the duplicated name and inv# where the inv# is the same.
The current incorrect report
----------------------------
Name pkg ctn lbs dimension Inv#
John Doe 1 1 10x10x12 200
John Doe 1 2 12x10x9 200
John Doe 1 5 9x18x5 200
John Doe 1 10 24x12x19 204
This is how the report should look
-----------------------------------
Name pkg ctn lbs dimension Inv#
John Doe 1 1 10x10x12 200
1 2 12x10x9
1 5 9x18x5
John Doe 1 10 24x12x19 204
Your assistance is once again required.
Thanks
Toukey
--- In MS_Access_Professionals@yahoogroups.com, toukey1 <no_reply@...> wrote:
>
> Thanks John
>
> 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
> >
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar