ive never really worked with access but what I am trying to do is have a macro that looks in the access file and the table is called "updates" and within that table I want it to look in the column called "station" and in the column called "date" and the column called "updates" to see if there is a match within a row.
so in my excel file range A2 has the station number so when the macro runs it looks at the value of cell A2 in the excel file and then trys to see if there is a match in the access file with todays date from "date" column and and the word UPDATED from the "update" column are in the same row together..
I know this probably sounds confusing... any questions just ask...
the excel path = C:\Users\user\Desktop\updates.xlsm
access path = C:\Users\user\Desktop\access updates.accdb
Bookmarks