473,326 Members | 2,192 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Viewing Data for Duplicates of Field

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
2 1411
Seth Schrock
2,965 Expert 2GB
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
zmbd
5,501 Expert Mod 4TB
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 bytes.com inbox.
Apr 18 '14 #3

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

Similar topics

1
by: SD | last post by:
Hi, This is driving me nuts, I have a table that stores notes regarding an operation in an IMAGE data type field in MS SQL Server 2000. I can read and write no problem using Access using the...
1
by: Paul Thakur | last post by:
I am writing vbscript code in an .asp page. I need to display field values from a sql table consisting of several fields, one of them is of type "Long Text". This field contains XML data. I like to...
1
by: Stu | last post by:
Hi, I am trying to return the data key field value from a dataset when I select a row in a datagrid after the datagrid has been bound to a dataset. When I an the Edit, Update and Cancel row I...
0
by: Bruce LeMond | last post by:
To my understanding the data key field property in the web form datagrid is used for finding the correct record in the data set for updating. It looks like only one field could be specified, but...
1
by: ReidarT | last post by:
I use a dataview to view records from an sql-database in a windows-form. When I use a select statement from a table like SELECT * FROM Table1 it works ok. objDataAdapter.Fill(objDataSet, "Table1")...
0
by: bluewave | last post by:
how to Demonstration data a field ms access inside a listbox?
4
by: mallz | last post by:
hi, in my jsp form i am entering the value for a field separated with blanks. but, while viewing it in a text box, it is truncating the characters after it encounters the first blank space. The...
3
by: mfetterhoff | last post by:
Hello Experts.. Im checking out the other side of the tracks here.. always been a Systems Analyst kind of guy. Developers are a touchy and unpredictible lot. I try to give them their space and never...
1
by: ritu raj shriwastaw | last post by:
I am using window xp and php trait(php3.1,mysql4.2).i have one field is of memo data type and I am unable to retrieve data from that memo data type field. what query I should write?
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.