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.
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
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
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
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
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
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
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
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
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
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.
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.
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
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
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
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
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
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
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
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
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