In Progress

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.

Skills: Microsoft Access, SQL

See more: software write mq4, software write chip epson, useful software write book, software write web specs, software write edid, software write websites idea, software write book images, software write books, software write protection, free software write book, software write book, software write technical manual

About the Employer:
( 4 reviews ) kirkland, United States

Project ID: #11773255

Awarded to:

MaoStuff

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 message More

$35 USD in 1 day
(1 Review)
1.1

29 freelancers are bidding on average $118 for this job

torajiv

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 go More

$100 USD in 3 days
(147 Reviews)
6.8
fabest

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 ser More

$147 USD in 3 days
(73 Reviews)
7.2
$80 USD in 2 days
(140 Reviews)
6.6
paris2785

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 draft More

$100 USD in 3 days
(78 Reviews)
6.3
wsh2

'Noodle,' an interesting data naming concept.. {smile}. Greetings Eric from Easton PA, USA. Highly experienced (25+ years) MsACCESS Business System, Programming, and Database expert with Guru / Mentor level techn More

$88 USD in 3 days
(17 Reviews)
5.7
A2Design

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 Fr More

$250 USD in 2 days
(2 Reviews)
5.8
fuentro

A proposal has not yet been provided

$111 USD in 0 days
(23 Reviews)
5.8
zu02

Hi, I'll do it during a day. Easy job. Specify Ms Access version. Thanks for your time. Skype zura_e Zura.

$155 USD in 3 days
(34 Reviews)
5.9
alaeddindhahri

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 fulfillin More

$80 USD in 0 days
(31 Reviews)
4.9
royalcalif

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% a More

$75 USD in 2 days
(23 Reviews)
4.8
crypthne

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 administ More

$166 USD in 7 days
(28 Reviews)
4.4
SergeyKyiv

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 th More

$35 USD in 1 day
(6 Reviews)
3.7
$300 USD in 10 days
(2 Reviews)
3.0
ankita0389

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.

$80 USD in 2 days
(4 Reviews)
3.0
arranmercer

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 heavil More

$100 USD in 3 days
(3 Reviews)
2.8
justTry

A place-holder for now, until I review teh attached database. A detailed offer will foolow.

$50 USD in 1 day
(4 Reviews)
2.5
medway25

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 experienc More

$50 USD in 1 day
(1 Review)
1.6
sergioobici

I suppose that noodle record is just an example ... how can I choose the record to which I have to uptade the city fields?

$155 USD in 5 days
(1 Review)
1.3
meeshusoft1

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 under More

$160 USD in 3 days
(1 Review)
0.6
HawkHouseInt

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 ti More

$277 USD in 5 days
(0 Reviews)
0.0