exp vg
asked on
Access - create table with duplicates across columns
I have a table with the following columns:
A - Name
B - Procedure
C - Outcome
D - Cost
The name in column A can appear on multiple rows.
I would like to create a new table B, that will export only records where columns B - D have repeat values. Example
Row 1: JOHN DOE - Foot Massage - Relaxed - $40
Row 2: JOHN DOE - Foot Massage - Tense - $40
Row 3:JOHN DOE - Foot Massage - Relaxed - $40
Row 4:JOHN OE - Foot Massage - Relaxed - $45
In this example, only rows 1 and 3 would be exported to the new table.
Thank you.
A - Name
B - Procedure
C - Outcome
D - Cost
The name in column A can appear on multiple rows.
I would like to create a new table B, that will export only records where columns B - D have repeat values. Example
Row 1: JOHN DOE - Foot Massage - Relaxed - $40
Row 2: JOHN DOE - Foot Massage - Tense - $40
Row 3:JOHN DOE - Foot Massage - Relaxed - $40
Row 4:JOHN OE - Foot Massage - Relaxed - $45
In this example, only rows 1 and 3 would be exported to the new table.
Thank you.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
Thank you everyone.
Use the wizard to create a find duplicates query. Then if you must physically capture the data, create a make table query that uses the find duplicates query you just created instead of the base table.