Access:  show only one instance of a name

Posted on 2012-09-13
Last Modified: 2012-09-13
i have a table with multiple instances of a name.


lastname    firstname       fullname           dob
smith          john               smith, john        01-01-1901
george        albert            george, albert    01-02-1905
smith          john               smith, john        02-09-1956

i want a query that will display the name only once..


lastname   firstname       fullname
smith         john               smith, john
george        albert            george, albert

Question by:intsup
    1 Comment
    LVL 29

    Accepted Solution

    Try this:

    SELECT DISTINCT lastname, firstname, fullname FROM NameOfTable

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now