Expiry Date Renewal

IN PROGRESS
Bids
34
Avg Bid (GBP)
£82
Project Budget (GBP)
£20 - £250

Project Description:
We download a CVS file containing the direct debit payment details of our members. This file contains their unique ID (Field: Client Ref) and their last paid date (Field: Last Paid). We would like a program that will read the details from the CSV file and then find the matching member in the MDB file (using Table: Members Details and Field: DD REFERENCE NUMBER) and then using their unique code number in the MBD (Field: Member Code) find the corresponding record in another table in the same MDB file (Table: Membership Card Details) and update the members expiry date (Field: Expiry Date) with the last paid date from the CSV file adding on another month (i.e. if the members last paid date was 14/06/2013, then the expiry date would be set to 14/07/2013). If there is no entry in the last paid column on the CSV then no change is to be made to the member record. I have attached sample CSV and MDB file for reference.

Skills required:
Database Administration, Microsoft Access
Additional Files: Data.mdb
Hire phototill
Project posted by:
phototill United Kingdom
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


£ 150
in 3 days
£ 111
in 1 days
£ 100
in 2 days
Hire expertcoder1vw
£ 31
in 1 days
Hire jhcannon
£ 100
in 1 days
Hire DenisSmolentsev
£ 150
in 5 days
£ 55
in 3 days
Hire davidgraf
£ 52
in 0 days
£ 53
in 1 days
£ 23
in 3 days