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

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 день
(0 відгуків(-и))
0.0

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

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 дні(-в)
(63 відгуків(-и))
6.9
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 дні(-в)
(136 відгуків(-и))
6.7
$80 USD за 2 дні(-в)
(119 відгуків(-и))
6.3
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 http://www.a2design.biz/portfolio_ Here’s a little video about our team too! ht Більше

$250 USD за 2 дні(-в)
(2 відгуків(-и))
5.8
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 дні(-в)
(59 відгуків(-и))
6.0
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 дні(-в)
(12 відгуків(-и))
5.5
fuentro

A proposal has not yet been provided

$111 USD за 0 дні(-в)
(18 відгуків(-и))
5.4
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 дні(-в)
(22 відгуків(-и))
5.5
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 дні(-в)
(5 відгуків(-и))
3.7
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 дні(-в)
(15 відгуків(-и))
3.7
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 дні(-в)
(7 відгуків(-и))
3.3
$300 USD за 10 дні(-в)
(1 відгук)
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
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 дні(-в)
(2 відгуків(-и))
2.8
justTry

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

$50 USD за 1 день
(3 відгуків(-и))
2.2
ITbeckham7

Hi,bro? Thank you for taking the time to review our Bid. In my opinion "Quality is never an accident." . My first aim to provide u quality and professional task. It will really be a great opportunity for us in Більше

$98 USD за 1 день
(1 відгук)
1.7
jssinfosys

Hi, I am an expert in MS Excel, MS Access, SQL database production and management. I have over 7 years of experience in working with all of the databases and analytics. I can successfully do this work as per your requ Більше

$80 USD за 1 день
(1 відгук)
1.0
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.0
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 відгук)
0.7
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