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.

Evner: Microsoft Access, Excel, Databehandling, Dataindførsel

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) Humble, United States

Projekt ID: #21268108

Tildelt til:


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

$25 USD in 2 dage
(0 bedømmelser)

30 freelancere byder i gennemsnit $28 på dette job


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 Flere

$30 USD på 1 dag
(258 bedømmelser)

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 Flere

$30 USD på 1 dag
(189 bedømmelser)

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 Flere

$30 USD på 1 dag
(256 bedømmelser)

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 Flere

$30 USD på 1 dag
(153 bedømmelser)

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 Flere

$30 USD på 1 dag
(113 bedømmelser)

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

$30 USD på 1 dag
(167 bedømmelser)

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 Flere

$30 USD in 2 dage
(52 bedømmelser)

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 Flere

$30 USD på 1 dag
(30 bedømmelser)

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 Flere

$30 USD in 2 dage
(20 bedømmelser)

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.

$25 USD in 2 dage
(9 bedømmelser)

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.

$30 USD in 3 dage
(8 bedømmelser)

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 Flere

$30 USD på 1 dag
(17 bedømmelser)

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 Flere

$30 USD in 7 dage
(4 bedømmelser)

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 Flere

$15 USD in 2 dage
(3 bedømmelser)

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 Flere

$20 USD in 5 dage
(4 bedømmelser)

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 Flere

$25 USD in 2 dage
(1 bedømmelse)

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) Flere

$25 USD på 1 dag
(1 bedømmelse)

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 Flere

$20 USD in 2 dage
(0 bedømmelser)

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 Flere

$20 USD in 7 dage
(0 bedømmelser)

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 Flere

$30 USD på 1 dag
(0 bedømmelser)