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 spreadsheet.
Last_Name First_Name Incurred_Date Pairing
Johnson James 1/1/12 1
Smith David 2/1/12 2
Johnson James 1/1/12 1
Johnson James 1/1/12 1
smith David 2/1/12 2
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 spreadsheet.
Last_Name First_Name Incurred_Date Pairing
Johnson James 1/1/12 1
Smith David 2/1/12 2
Johnson James 1/1/12 1
Johnson James 1/1/12 1
smith David 2/1/12 2
Last edited: