Search results

Sorry if its confusing. What I do manually to populate the "Pairing" field is look at the First_NM, Last_NM, and Incurred_DT, if those criteria matches, then I put matching numbers under the "Pairing" field. I am looking for a query or macro to do this automatically for me.

Thanks for the input Adam Caramon. This is a sample data that I pulled from my database. My actual database is setup similar to what you suggested. What I am trying to do is use the macro or query to clean my import table before I run an update macro. Currently, what I do is manually looking at...

The "Pairing" will be empty until the query or macro is ran. I populated the "Pairing" field to show you what I wanted to end up with. Apologies for not mentioning it. "Corresponding" means input the same number in "pairing" if Last_NM, First_NM, and Incur_DT matches.

Sorry, I exported the data into an excel. Here is the sample database in Access.

Here are the details. Table Name = Cost_Data Sample file is attached. What I am looking for is: If Last_NM, First_NM, and Incur_DT matches, then add a corresponding number to field "Pairing".

Thanks for the response. I will gather the details and post it.

Hi, I am new to the this forum and a beginner in Access. Here is the macro that I am looking for: If Last_Name, First_Name, and Incurred_Date matches, then input corresponding number in field called “Pairing.” Any help would be greatly appreciated! Thanks Here is an example of the...

Hi All, I am new to this forum and looking forward to learning additional knowledge for Microsoft Access. I am new to Access, but have taken tutorials and already started creating my database with queries and forms to help me navigate through all my records. Thanks in advance for all your help!