Re: Unique records
- From: "Duane Hookom" <DuaneAtNoSpanHookomDotNet>
- Date: Sun, 29 Oct 2006 18:58:28 -0600
Try
SELECT A, B, C, D, Min(E) as MinE, Min(F) as Min(G) as MinG
FROM [which looks like this]
GROUP BY A, B, C, D;
--
Duane Hookom
MS Access MVP
"Sean" <Sean@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:54D1EF7C-0E43-4C9C-AAE4-38E84ED6F9FD@xxxxxxxxxxxxxxxx
Hi,
I have a table which looks like this:
A B C D E F G
1 2 3 4 5 6 7
1 2 3 4 6 7 8
1 2 3 4 7 8 9
1 2 3 4 8 9 1
1 2 3 4 9 1 2
2 3 4 5 6 7 8
2 3 4 5 7 8 9
2 3 4 5 8 9 1
2 3 4 5 9 1 2
Columns A,B,C and D have duplicates but E,F and G have no duplucates. I
need
a query that gives me unique A,B,C and D and any of the E,F and G records
but
just one. It could be the first or second, doesn't matter but I need one
row
for A,B,C and D.
Is this possilble?
thanx
.
- Prev by Date: Re: Query with specific months
- Next by Date: Combo Box to Text Box Calculation
- Previous by thread: Re: Query with specific months
- Next by thread: Combo Box to Text Box Calculation
- Index(es):
Relevant Pages
|
|
