Good afternoon, and thank you for taking the time to read my dilemma. Sorry - trying to edit three fields rather than just a single field.
I've been tasked with creating a database that will keep track of eligible accounts. I'll receive several Excel spreadsheets throughout the week to be imported; some will be new records, so will be updates to existing records. Importing new records into the table isn't a problem, but when one or several of those records are duplicates, I'll need to update three fields in the existing record to indicate that that record/customer has been contacted. My first attempt at writing the necessary SQL resulted in this:
Code:
INSERT INTO tblScrappyData ( OBC, Eligible, EDate )SELECT True AS OBC, False AS Eligible, Date() AS EDate
FROM tblContactedListTemp
WHERE (((tblContactedListTemp.[Member ID])=[tblScrappyData].[MID]));
When I run that code I'm greeted with Access' Enter Parameter Value window, requesting that I enter tblScrappyData.MID. Is this not something that can be done with a query? If that isn't possible, how do I accomplish this?
I hope I've communicated my problem sufficiently. 'preciate any help I can get.