By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,396 Members | 1,476 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,396 IT Pros & Developers. It's quick & easy.

Viewing Data for Duplicates of Field

P: 1
I have a Table with NAME as Field1. There are multiple duplicate NAME records. Fields2 - Field4 have data for that I would like to view under that name.

For example:

4 Jane Doe EDUC Left_Voicemail Education_issue
5 Jane Doe EDUC Phone_Call School_Meeting

I would like to view all the data for Jane Doe under a single form. I am a Microsoft Access novice. Any advice is appreciated.
Apr 17 '14 #1
Share this Question
Share on Google+
2 Replies

Seth Schrock
Expert 2.5K+
P: 2,951
You would use a query for that. Create a new query and open it in SQL view (how to do this depends on what version of Access you are using). Now enter the following (correcting the names of course)
Expand|Select|Wrap|Line Numbers
  1. SELECT * 
  2. FROM YourTableNameHere
  3. WHERE Field1 = 'Jane Doe'
If Field1's actual field name is "Name" (which would be bad because that is a reserved word), then you would need to surround it in square brackets ([]). Now granted, this is very manual in that if you want to look for John Doe, you have to go back into Design or SQL view to change the name, but without more details about how your database is setup, we can't go much farther in helping you. Also, if someone entered two spaces between Jane and Doe, then that record wouldn't be found. Also misspelling. Capitalization would depend on the settings of the database.

If this is a database that you are designing, then you should look at Database Normalization and Table Structures for information about how best to structure your tables in a way that makes everything much easier.
Apr 18 '14 #2

Expert Mod 5K+
P: 5,397
To underscore Seth's mention:
Access 2007 reserved words and symbols
AllenBrowne- Problem names and reserved words in Access

I've also pm'd you a copy of information for new Access programmers. Please check your inbox.
Apr 18 '14 #3

Post your reply

Sign in to post your reply or Sign up for a free account.