I am creating a new query in MS Access that updates an existing record based on the "Branch" and "Employee" fields. How can I set the criteria to reference cell values? Say, $A$2 holds the "Branch" ID for Access and $B$2 holds the value for the "Employee" ID in Access.I want to update my Access "Notes" Field. My query works when running in Excel, but only because I have specified what the "Employee" & "Branch" ID's are. Unfortunately I cannot post my Query on this site
Nothing updates when i run my code below:
Bookmarks