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 freelancere byder i gennemsnit $28 på dette job
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.