• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 468
  • Last Modified:

Access: show only one instance of a name

i have a table with multiple instances of a name.

example:

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..

example:

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

thanks!!
0
intsup
Asked:
intsup
1 Solution
 
IrogSintaCommented:
Try this:

SELECT DISTINCT lastname, firstname, fullname FROM NameOfTable
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now