Completed

Access Module to convert data from one format to another using concatenation

Hi there,

Requirement below then requires option to reverse the process.

Module required to convert postcode from list form to condensed short form. So 2 tables.

1. Postcode Gazetter 2015

2. Postcode UK Pricebooks

We need to create the table as a make table query in Postcode UK Pricebooks from the data in Postcode Gazetter 2015. It needs to follow a strict format.

So 79 records for B Postcode which all go into Zone 1 so will display simply as B it will then break with a , and the " " and then display the next alphabetic record which is BB and so on.

When the postcode appears in 2 zones eg. BD it needs to be broken and display the postcode district numbers so BD1-22,97,99, then space then BL. The remainder of BD that cross refers to BD will be in zone 2.

Zone 1 - B, BB, BD1-22,97-99, BL, CH, CV, CW, DE, DN1-12,16-17,21-22,31-35,40-41,55, DY, GL1-4,7,14,

Zone 2 - BD23-24,

Ultimately the table will looks as per Postcode UK Pricebooks but created from a make table query from Postcode Gazetter 2015.

Database attached.

Skills: Excel, Microsoft Access, PHP, Software Architecture, Visual Basic

See more: concatenate column values from multiple rows into a single column with access, ms access concatenate fields in table, combine rows in access query, ms access concatenate column values, access query concatenate multiple records, access concatenate sql, access combine two fields into one, access query combine multiple records into one record, easy convert mla format, convert flv format dvd player can view, insert data xml using vbnet, convert eps vector format using photoshop, access 2000 convert 2007 format, convert xls file dat format using, convert files dat format using, function module convert xls file xml format sap, convert data mysql pdf format php, convert dat format xls data, convert data applications access database standalone executable file, convert stata data format

About the Employer:
( 5 reviews ) Alrewas, United Kingdom

Project ID: #17857544

Awarded to:

dawarshiwani

Hello, Greetings!! I have read and understood yours job requirement and very much able do this job. I have more than 5 years of experience in PHP,Various CMS,Various MVC Jquery,MySQL. Some of the prominent pro More

£18 GBP in 1 day
(0 Reviews)
0.0
frlncrsZviDAyqG

Hello This should not present a problem in creating the CSV style output in pricebooks from the raw gazetter if the correct initial sort patterns are used on the source table. I can start this for you after lunch More

£23 GBP in 2 days
(1 Review)
1.0

10 freelancers are bidding on average £38 for this job

kolosibalint

Hi, It took a few minutes to understand what you mean but now the rules are clear. I would say it would be easy to do with SQL if the postcodes with the same letters always belonged to the same zone. Since it's not More

£120 GBP in 1 day
(104 Reviews)
6.5
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl More

£20 GBP in 2 days
(109 Reviews)
6.2
zu02

Hi, there I hope all's well with you. I'll do your current via Ms Access work - very professionally and on time. Here is my introduction: I’m a ms Access/Excel/VB programmer, a mathematician and a full tim More

£98 GBP in 2 days
(54 Reviews)
6.2
EngrShahidul

I am experience SPSS, Minitab. Excel. Presentation, Power pivot table, regression (Trend line) & correlation analysis, statistical test, linear programming, formula creation, graph creation and report writing. You m More

£23 GBP in 1 day
(16 Reviews)
4.3
wordpress247

Hello, After reading your offer this looks like a perfect fit for my skill sets. I have built a large number of creative designs /Development for different businesses. My name is Gopal V and I am an Indian web De More

£18 GBP in 1 day
(4 Reviews)
3.7
Longe001

I Will get it done for you in no time due to my experience in this field

£18 GBP in 1 day
(0 Reviews)
0.0
noumanishfaq93

Hello Sir/Ma'am I have read your project description and i can do this work. I have understand the project requirements and it can be done in the code language of your requirement. If we can have a chat then that woul More

£18 GBP in 3 days
(0 Reviews)
0.0
bbbssolutions

*** Expert in MS Access 1. 10 Years of experience 2. Expert in ASP.net,C#.net,VB.net,Sql server,MySql,MS Access,Crystal Report 3. Worked in almost 150 projects. 4. Dedication,timely execution and perfection is ou More

£20 GBP in 10 days
(0 Reviews)
0.0