Go Back   Access World Forums > Microsoft Access Discussion > General

Thread Tools Rate Thread Display Modes
Old 11-09-2018, 06:48 PM   #1
Newly Registered User
Join Date: Nov 2018
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
plshelpmewithcommas is on a distinguished road
HW Something about commas and multiple things in one field idrk

So I admittedly dont pay attention enough in class and have a HW assignment due tonight on a database which i've figured my way through up until now.

Basically my issue is I have a thing whith an area of expertise for a job/contract that has area type of expertise in it and a desc. of that area of expertise.
The problem is some jobs require more than one area of expertise and contractors have more than one area, in the excel data that I have to convert its separated by a comma, so I just entered it by hand with a comma separating the expertise code (three letter abbreviation, youll see in the attachments).

When I try to make a relationship between the two areas it obviously doesnt let me because theres a comma in there.

I entered data before creating the relationships which is probably a poor move but whatever.

Basically my question is how do I get access to read the different required expertises (separated by commas) in the same field or whatever.
Attached Images
File Type: png Capture.PNG (12.1 KB, 13 views)
File Type: png Capture2.PNG (13.0 KB, 10 views)
File Type: png Capture3.PNG (13.1 KB, 8 views)
File Type: png data.PNG (52.9 KB, 11 views)
File Type: png relationship.PNG (82.6 KB, 12 views)

plshelpmewithcommas is offline   Reply With Quote
Old 11-09-2018, 07:40 PM   #2
Happy Retired Curmudgeon
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 13,136
Thanks: 70
Thanked 1,377 Times in 1,269 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: HW Something about commas and multiple things in one field idrk

Due tonight? I suspect your problem is going to take longer than that to implement.

By any chance, do you recall whether your instructor talked about normalization? Because what you have literally screams "unnormalized."

What you SHOULD have done was to break up your three-character specialty codes so that you would have a child table enumerating (listing) the codes in a record that was a child of the contract. You also a similar table as a child of the contractor record.

Then the data file you showed us lists contractors in a way that should be normalized as well. You had records listing "Contractor 1" and "Contractor 2" which should have been stored in a contractors table with an arbitrary contractor ID field (yes, which COULD have been as simple as 1 or 2...).

The amount of work to be done is beyond the typical level of support that we give around here, particularly for someone who neglected his class work. With more time, we might have guided you to a good conclusion but if this is due tonight I don't have an answer for you and have no desire to do your work for you. I won't be the one getting the grade. If someone else takes this on, good for you. But this is not something I care to attempt on short notice with too little time.
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Count commas in a field ScottXe Queries 3 11-21-2014 09:41 AM
Import Fixed-width Text file (field with commas)LE onisdad Modules & VBA 5 05-14-2013 09:37 AM
Checking multiple fields and doing different things based on those results xPaul Modules & VBA 13 04-05-2013 04:54 AM
count number of commas in a field lala Forms 12 12-23-2009 06:53 PM
Split Data In One Field Into Two -- With Commas databasedonr Queries 8 06-24-2003 01:27 PM

All times are GMT -8. The time now is 12:35 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World