Jose C
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!!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.