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.

Taidot: Microsoft Access, Excel, tietojenkäsittely, tiedonsyöttö

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Humble, United States

Projektin tunnus: #21268108

Myönnetty käyttäjälle:


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 2 päivässä
(0 Arvostelua)

30 freelanceria on tarjonnut keskimäärin 28$ tähän työhön


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 Lisää

$30 USD 1 päivässä
(258 arvostelua)

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 Lisää

$30 USD 1 päivässä
(189 arvostelua)

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 Lisää

$30 USD 1 päivässä
(256 arvostelua)

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on I am ready to carry out your project in the reasonable price and in the shortest possible Lisää

$30 USD 1 päivässä
(153 arvostelua)

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 Lisää

$30 USD 1 päivässä
(113 arvostelua)

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

$30 USD 1 päivässä
(167 arvostelua)

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 : Here is my in Lisää

$30 USD 2 päivässä
(52 arvostelua)

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 Lisää

$30 USD 1 päivässä
(30 arvostelua)

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 Lisää

$30 USD 2 päivässä
(20 arvostelua)

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 2 päivässä
(9 arvostelua)

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 3 päivässä
(8 arvostelua)

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 Lisää

$30 USD 1 päivässä
(17 arvostelua)

I have done a similar Access projects before with 5* ratings: • • Lisää

$30 USD 7 päivässä
(4 arvostelua)

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 Lisää

$15 USD 2 päivässä
(3 arvostelua)

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 Lisää

$20 USD 5 päivässä
(4 arvostelua)

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 Lisää

$25 USD 2 päivässä
(1 arvostelu)

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) Lisää

$25 USD 1 päivässä
(1 arvostelu)

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 Lisää

$20 USD 2 päivässä
(0 arvostelua)

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 Lisää

$20 USD 7 päivässä
(0 arvostelua)

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 Lisää

$30 USD 1 päivässä
(0 arvostelua)