Xen Parker
asked on
MS Access 2007 - Suppressing data repeats
I am looking for a query that will do the following:-
I have a Customer John and a Salesman Mike in my sales table such that John buys 6 different items (laptop, tablet, shredder, stapler) from salesman Mike.. The query result will look like this:
Customer Salesman Products
------------ -------------- -------------
John Mike Laptop
John Mike Tablet
John Mike Shredder
John Mike Stapler
I want to be able to have the results as follows (only showing the occurrence of John and Mike once only as follows
Customer Salesman Products
------------ -------------- -------------
John Mike Laptop
Tablet
Shredder
Stapler
Is this do-able ?
I have a Customer John and a Salesman Mike in my sales table such that John buys 6 different items (laptop, tablet, shredder, stapler) from salesman Mike.. The query result will look like this:
Customer Salesman Products
------------ -------------- -------------
John Mike Laptop
John Mike Tablet
John Mike Shredder
John Mike Stapler
I want to be able to have the results as follows (only showing the occurrence of John and Mike once only as follows
Customer Salesman Products
------------ -------------- -------------
John Mike Laptop
Tablet
Shredder
Stapler
Is this do-able ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
OP asked for a query.
Report approach was considered many times in this forum.
OP did not intervene to specify his preferences.
Report approach was considered many times in this forum.
OP did not intervene to specify his preferences.
and table need to have a unique key
If table does not have a unique key, then extra code is needed to add a unique sequence in query.
Upload a sample table for further comments.