MS Access Data Consolidation

Seeking someone with experience with MS Access.

I have raw property data that shows how much is owed by the property owner for each year. I would like to consolidate all of the years down to a single row, showing the total amount owed for all years. All other data columns should remain intact. I just need the entries with multiple years combined into a single row.

The image below shows a sample the data that have and into the data I would like.


>In the column, NAMEANDADD5, I would like the city and state data separated. NAMEANDADD5 will have the city. The state will be in a new column, NAMEANDADD6.

>I would like the format of the data in the last 3 columns (LANDVALUE, IMPROVEMENT, TOTALVALUE) to be changed into a normal number format without the preceding zeros.

I collect this raw data quarterly and would like to work with someone who can perform this on an ongoing basis. Please let me know if you have any clarifying questions.

Compétences : Microsoft Access, Excel, Traitement de Données, Saisie de Données

en voir plus : accesse data ms access search vb, coding save data vb ms access, creat data base ms access, create data entry software ms access, customize ms access template existing data, data decrypted ms access database, data entry application html javascript ms access, data process manager jobs ms access, extract images stored ms access database long binary data format, function inserting data ms access desktop application, import data ms access excel net, import data odbc ms access, merge data ms access ms projects, ms access data entry, ms access data entry experience, ms access data entry multiple users, ms access ejb3 data source, ms access data entry form, ms access data entry form examples, ms access data entry forms

Concernant l'employeur :
( 0 commentaires ) Humble, United States

Nº du projet : #21268108

Décerné à:


Hello, I have extensive experience in MS Access dstabase development including table management, queries, forms, reports, and VBA. I can complete this task quickly and with a high degree of accuracy. Thanks Roger

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 2 jours
(0 Commentaires)

30 freelance font une offre moyenne de $28 pour ce travail


Hi, there! My name is Paris, and I was glad to see that you're looking for an Access developer. According to your brief, you want to have a query that will retrieve your data and present it in the format as seen in the Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(258 Commentaires)

Hello Sr./Madam Hope you read my proposal and take a look into my Portfolio to see my reputation and capabilities. I am an experienced Windows Desktop Apps Developer (C#, C++), Web Data Extractor & Automator (using dif Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(189 Commentaires)

Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(256 Commentaires)

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 possible Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(153 Commentaires)

Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your requirements. Let me know the full specification of the project to calculate the approp Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(113 Commentaires)

Please share your access file, I can convert to a single row. Thank you.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(167 Commentaires)

Hi, there text me on s k y p e zura_e I hope all's well with you. I'll do your current project via Ms Access - very professionally and on time. Please visit :https://www.freelancer.com/u/zu02?w=f Here is my in Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(52 Commentaires)

Hi, I am a professional MS Access and SQL database developer with 10+ years of corporate experience. I am developing MS Access since 2008 and SQL server database since 2012. I can provide you best and long term suppor Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(30 Commentaires)

Hi there, Greetings! I think, I have understood your requirements. Here me out - The output needs to be sum based on the City and Year. Right? I am an experienced MS Access developer. I have been developing custom d Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(20 Commentaires)

Dear Sir, Madam, I'm proficient in Ms Access, I have long years experience developing applications with. Looking forward to work with you. Thanks and regards.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(9 Commentaires)

Hi, I am interested. I have considerable expertise in the design and development of MS Access databases. I would be happy to discuss about your requirement. Regards.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(8 Commentaires)

Hi there, let me help you on this project I am available and ready to start this project Immediately, and you can trust me to deliver you a good result on this project. Please try me once and I assure you superior qua Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(17 Commentaires)

I have done a similar Access projects before with 5* ratings: • https://www.freelancer.com/projects/database-programming/legal-finances-database-improvements/ • https://www.freelancer.com/projects/php/build-ACCESS-Dat Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(4 Commentaires)

Hello, as a CS student I have experience working with databases of all kinds including MS Access databases and queries. I'm confident that I will be able to finish this project on time and without error. Also I would b Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(3 Commentaires)

Hi there! I've read your requirements and looked at your screenshots. I've been working with MS Access for years and I have a good practical mastery of this application, having used it to store and process all kinds of Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(4 Commentaires)

Hello I've many years in database manipulation and can perform these transformation with some basic VBA text/numeric manipulations. It can also be built to enable the conversions to be done whenever you require withou Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(1 Évaluation)

Hi, Currently i am working on Microsoft Products VB.NET, C#.NET, SQL, VBA in excel, access.  My recent projects are,  * Scrap/Crawl Amazon Products with Details based on Search Keywork * Excel ADD-In (like Extension) Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)

Dear Sir, Experts and experiments team here Manually Collect Data Entry Work. Can you please send me details so that I can submit some entries and it will help you have an idea about the Quality of our work and exact t Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)

I will build a powerful database using Microsoft Access that will send your productivity soaring! If you're already trying to manage your data on a spreadsheet, it's time to do it right with a database! I will colle Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)

Hi There, I have gone through the file [login to view URL] (Been There Done That). I can easily handle this and get the results back quickly. Can easily handle it on an ongoing basis. Please do let me know if you have any quest Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)