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.
Hi Russ, Thanks for inviting me to this project. I'm very interested and would like to help you again with this. Can you send me the details of the 4 tables? Regards, Susanto
23 freelancers are bidding on average $76 for this job
I can give u simple application, you will select the access database and click on process button. Applicaiotn will automatically put data in respective tables.