You key-
Same property on the Inv# control.
John
Sent from my iPad
On Sep 17, 2013, at 15:33, "toukey1" <no_reply@yahoogroups.com> wrote:
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
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (7) |
Tidak ada komentar:
Posting Komentar