-
Selecting Only the First Row in a Query
Say a number of people have 2 or 3 addresses each in a query result.
How do I select only the first address displayed for each person.
For example:
John Taylor 33 Dundas Ave.
John Taylor 55 Shane Ave.
John Taylor 786 Edward St.
Ted Charles 785 Bloor St.
Ted Charles 90 New York Ave.
All I want is the first address that is displayed for each person
which is:
John Taylor 33 Dundas Ave.
Ted Charles 785 Bloor St.
Wondering if this is possible in Access?
Marcus
******
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|