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

Completado Publicado hace 5 años Pagado a la entrega
Completado Pagado a la entrega

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.

Excel Microsoft Access PHP Arquitectura de software Visual Basic

Nº del proyecto: #17857544

Sobre el proyecto

7 propuestas Proyecto remoto Activo hace 5 años

Adjudicado a:

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 Más

£18 GBP en 1 día
(3 comentarios)
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 Más

£23 GBP en 2 días
(2 comentarios)
1.7

7 freelancers están ofertando un promedio de £46 por este trabajo

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 Más

£120 GBP en 1 día
(130 comentarios)
7.0
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 Más

£20 GBP en 2 días
(213 comentarios)
6.9
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 Más

£98 GBP en 2 días
(60 comentarios)
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 Más

£23 GBP en 1 día
(40 comentarios)
4.8
Longe001

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

£18 GBP en 1 día
(0 comentarios)
0.0