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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.