Select 1st value info repeated in table

  • Thread starter Thread starter Vigilstar
  • Start date Start date
V

Vigilstar

I am trying to build a query that will select only the 1st value foun
from [AMDFLIN], if the value is repeated as with A06352, the quer
would pass the other three listing of A06352 and give me the next valu
of A06420.

AMDFLIN..AMDFNSN
A06043...6830-00-264-6751
A06352...5855-01-138-4749
A06352...5855-01-475-7061
A06352...5855-01-439-1745
A06352...5855-01-439-1744
A06420...5855-01-138-4748

I trying to pull the information directly from a Table. I need th
query to help run Crosstab query. I have pretty much tried everything
I really don't know what to do next. This is my first posting, i
anyone out there knows how to do this please let me know.

PS. I put in the periods to help separate the fields I am explaining.
Thanks in advance
 
Question? How do you determine which is the FIRST value. Is it the one that
occurs first if you sort by admflin and amdfnsn? Or is some other method used
to determine FIRST, such as a datetime field? IF all you want is to get one of
the values for amdffnsn and you don't care which one, you could use a totals
query and the FIRST, LAST, MIN or MAX function.

SELECT AMDFLIN, FIRST(AMDFNSN)
FROM YOUR TABLE
GROUP BY AMDFLIN
 
Back
Top