unique with 2 columns

[CHARI]

I have 2 columns with duplicates in the first column and no duplicates in the
second. I neeed to only see one value for each in the left and only one of
the accounts from the right.

ie: abc 1234
abc 12345
bcd 251
eft 600
eft 607
I would like to see either of the abc with the 1234 or 12345
I would like to see the bcd since it's individual with the 251
I would like to see either of the eft with the 600 or the 607

 

[John Spencer]

Use a totals query and one of the aggregate functions (First, Last, Min, or
Max) on the Accounts column

In Design view
-- Add both fields (fldRight and fldLeft)
-- SELECT View: Totals from the menu
-- Change GROUP BY to First (or last or min or max) under fldRight
-- Run the query.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[CHARI]

worked wonderful, thank you!!!

Use a totals query and one of the aggregate functions (First, Last, Min, or
Max) on the Accounts column

In Design view
-- Add both fields (fldRight and fldLeft)
-- SELECT View: Totals from the menu
-- Change GROUP BY to First (or last or min or max) under fldRight
-- Run the query.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..