Access gives you a way to pull values from a field, based on selection
criteria.
Are you saying you have more than one fact in a field (e.g., "John J.
Smith")?
Open a new query in design mode. Add a table (or another query). Select
the fields you want to see, sort by and select by. Set these (sort,
select). Run it.
Regards
Jeff Boyce
Microsoft Office/Access MVP
