Link to home
Start Free TrialLog in
Avatar of Jose C
Jose CFlag for United States of America

asked on

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!!
ASKER CERTIFIED SOLUTION
Avatar of IrogSinta
IrogSinta
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial