Write some Software

Scenario: you have a table in an access database and one of the fields is called tbl_raw_content. In one of the fields called “content” you have a record populated with the following city names “Luohe, Jiaozuo, Weihui, Wugang”. You then run a query that pulls out the city names and inputs each city name into the individual city fields in the table tbl_city_data on the record with the field that has noodles.

I have two issues I am trying to solve:

1. Pulling the city name out of the content – that is why I included a table called tbl_country_city because there should be some sort of look up.

2. Putting an individual city name into an individual field in a new table. This should be an update query and not an append because I want these four cities associated to the ‘Noodle’ record.

Przyznane użytkownikowi:

Hi,
I downloaded your accdb and I wrote a function to separate the citys, I can send you a screenshot to show u how it works, a query will update the table tbl_city_data in relation with the ID_2 , send me a messageWięcej

Hello
I am an exclusive MS Access developer completely dedicated to this platform - I do not work on any other platform.
I am also among the top three MS Access developers on this site.
You can verify by goWięcej

Dear, we are Team of French + US.
I checked your project description, and I confirm I can develop your program.
I will focus on user friendly interface.
As you can see I have very good rate, you can be sure I am serWięcej

Hi there - My name is Paris.
I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draftWięcej

Hi,
Nice project you have there, let us help you with it!
Our team is Russian-Canadian. We code in PHP.
Check our recent projects here [The administrator removed this message for encouraging communication outside FrWięcej

Hi,
I'm a professional Microsoft Access and VBA developer with strong background in developing and modeling information systems using Ms Access. I have read your project description and would like to help you fulfillinWięcej

Really i wish to get little bit more about the task. so please pm me. you may award me after see the sample.
Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% aWięcej

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administWięcej

Greetings!
My name is Sergey Murzin, I'm from Kyiv, Ukraine.
I have 20 years experience with MS Excel/Access/VBA.
Any code I provide is well structured and commented, client gets whole access and rights for thWięcej

I am a faculty teaching the topic of DBMS (sql) to university students, I deal with similar problems in my day to day life. I hope I am a perfect candidate for this task. Please initiate the chat to take this further.

Hello from across the pond!
I am a certified Microsoft Office specialist who works as a data analyst. I live and breathe database creation, data manipulation and automation through VBA. this task lends itself heavilWięcej

This seems straightforward and is the sort of problem resolution that interests me. If you assign me the work I'll have the solution to you within one day.
---------------------------------------
I’m an experiencWięcej

After seeing your database, I could not gather the purpose. I can write a code which will extract names found in the content field and create a new table. But how are you going to link that to "noodle".
Let me underWięcej

Hello. Our company exists since 2014 and at the moment we are aimed on expansion abroad. We have already implemented more than 70 projects in Russia and CIS. And we are ready to take new projects and execute them on tiWięcej