first row I think

  • Thread starter Thread starter wo tanlemary
  • Start date Start date
W

wo tanlemary

Hello - I am stuck - can you please help
I have two tables in a qry - but I want to get the only
the first time that there is a match just - like record
count 1 -- I don't want all the matches but rather just
the first -- then I will export that to a new table
I can run a second qry selecting the second match and so
on...can anyone please help on how to do this..thanks in
advance Mary

eg.

tbl_one
Field ID_AUTO

tbl_two
Field ID_Auto (link)
Field GPNo

I want the first match of Field regardless of GPNo
field....can anyone tell me how
and then I want to do that again...for second time I get
a match -- and make a table from each of those separate
matches.


Thanks in advance -- Mary
 
Take a look at the "TOP" parameter -- you can limit a query to return the
"TOP 1". Also look into Totals query, using the "Max" (or "Min") grouping.

By the way, what you think of as the "first" match may not be what Access
considers as "first." How are you determining order?

Good luck

Jeff Boyce
<Access MVP>
 
Hello and thanks -- I am trying to do is
I have a one side to many side
I want it to just provide the second time when that match
occurs in the query I already have done a "first". For
most instances I have just one record but I need to pull
out if there are more (they aren't duplicates) - but just
a match -- And some many cases there are more than two --
sometimes up to 12--

does this help I need a record of each instance
separately--
I hope this helps...
 
Mary

Another approach might be to use the UniqueValue property of your query,
which would return only one of each.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top