Completed

MS Access Macros - update fields based on SQL query results

This project was successfully completed by sswijaya for $50 USD in 3 days.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
$30-$250 USD
Completed In
3 days
Total Bids
25
Project Description

I need some MS Access Macros that call SQL queries to check fields in an existing Table in the database, and populate fields in another Table based on the results.

I have 4 specific fields in Tables that need to be updated automatically via this method, so 4 separate Macros and (multiple) SQL queries. I can provide the specific details and sample Access database.

An example of the most complicated of the 4:

----------------------

MS Access User Table (USER_TABLE) consisting of 3 fields: Customer_Number, User_Name, and Email_Address. I have another table (NEW_USERS) that consist of new requests for Users. It has a User_Status field that is blank by default, and also has the Customer_Number, User_Name, and Email_Address fields.

Half of the new requests that come through are users already existing, so I want to set up a query that will check the USER_TABLE to determine if a new request exists or not, using the Email_Address field checked vs. the Customer_Number field. Complicating this is the fact that 1) Customer_Number is not unique (many Users exists for a single Customer Number) and 2) Users can have multiple accounts for different Customer Numbers. This results in 4 scenarios in the NEW_USERS table when checking vs. the USER_TABLE:

Email_Address does not exist for Customer Number in USER_TABLE (New)
Email_Address exists for Customer Number in USER_TABLE (Existing)
Email_Address does not exist for Customer Number in USER_TABLE, but exists for other Customer Numbers (New-Multi)
Email_Address does exist for Customer Number in USER_TABLE, and also exists for other Customer Numbers (Existing-Multi)

What I would like to do is run these checks and enter the corresponding result (New, Existing, New-Multi or Existing-Multi) into the User_Status field.

-------------------------

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online