В роботі

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.

Навички: Microsoft Access, SQL

Показати більше: software write mq4, software write chip epson, useful software write book, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, software write book images, software write books, software write protection, free software write book, software write book, software write protect software, software write technical manual

Про роботодавця:
( 4 відгуки(-ів) ) kirkland, United States

ID проекту: #11773255

Доручено:

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 Більше

$35 USD за 1 день
(1 відгук)
1.1

28 фрілансерів(-а) подали заявки на цю роботу; середня заявка - $121

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 Більше

$100 USD за 3 дні(-в)
(147 відгуків(-и))
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 Більше

$147 USD за 3 дні(-в)
(73 відгуків(-и))
7.2
$80 USD за 2 дні(-в)
(142 відгуків(-и))
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 Більше

$100 USD за 3 дні(-в)
(80 відгуків(-и))
6.4
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 Більше

$88 USD за 3 дні(-в)
(17 відгуків(-и))
5.9
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 Більше

$250 USD за 2 дні(-в)
(2 відгуків(-и))
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 за 3 дні(-в)
(35 відгуків(-и))
5.9
fuentro

A proposal has not yet been provided

$111 USD за 0 дні(-в)
(24 відгуків(-и))
5.8
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 Більше

$80 USD за 0 дні(-в)
(32 відгуків(-и))
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 Більше

$75 USD за 2 дні(-в)
(26 відгуків(-и))
4.9
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 Більше

$166 USD за 7 дні(-в)
(28 відгуків(-и))
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 Більше

$35 USD за 1 день
(6 відгуків(-и))
3.7
$300 USD за 10 дні(-в)
(2 відгуків(-и))
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 за 2 дні(-в)
(4 відгуків(-и))
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 Більше

$100 USD за 3 дні(-в)
(3 відгуків(-и))
2.8
justTry

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

$50 USD за 1 день
(4 відгуків(-и))
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 Більше

$50 USD за 1 день
(1 відгук)
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 за 5 дні(-в)
(1 відгук)
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 Більше

$160 USD за 3 дні(-в)
(1 відгук)
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 Більше

$277 USD за 5 дні(-в)
(0 відгуків(-и))
0.0