First entry query

  • Thread starter Thread starter fgwiii
  • Start date Start date
F

fgwiii

Site Title Fname Lname
==============================
001 SC Karen Lome
001 SA Joan Smith
051 ADM Jon Gorz
051 SC Fran Rera
051 MD Joan Glitz
066 SA Liz Mena

I need a query that returns the just first entry/row for
each site number and ignores the rest of the info for that
site. See below:

Site Title Fname Lname
==============================
001 SC Karen Lome
051 ADM Jon Gorz
066 SA Liz Mena

Any help will be greatly appreciated!
 
Fred

You provided an (ordered) list. Access stores data in "buckets". How will
Access know which of the "051" records is the "first"?
 
Jeff,

Whichever listing appears first in the table. If I ordered
the data first by site number and the whenever the site
number changed, take the first row??

Fred
 
Fred

Let me restate ... Access does NOT inherently store information in any
(usable) order. Even if you see the table appearing to be in an order you
want, there's no guarantee that Access will use that when you build a query.

You will need to add a new field to come up with some way for Access to
differentiate the order. Some possibilities include a user-generated
sequence number, a date/time, or an "autonumber" field.

Without the use of a field like one of these, you won't be able to tell
Access how to "see" which one is "first".
 
Back
Top