Append Query in Access - error "cannot find field"

Question

Hi all!

I am having a problem with an append query.  When I click "View," it shows the correct results, but if I try to run it, I receive the following error:  "Could not find field 'EndDate'."

Here is my query.  I can't find any issues with the "End Date" field in my "Current Employees" table, so I can't figure out what is wrong!

INSERT INTO FormerEmployees ( FEEmployeeID, FEStudentID, FEPositionID, FEEmploymentStatus, FEWorkStudyAward, FEStartDate, FEEndDate, FEReasonForEnd, FEReasonForEndNotes, FEBackgroundCheckCompleted, FECleryTrainingCompleted, FENotificationSenttoHD, FEInstructionsSent, FEOfferSent, FEOfferAccepted, FEDateAdded, FESelect )

SELECT [CurrentEmployees].EmployeeID, [CurrentEmployees].StudentID, [CurrentEmployees].PositionID, [CurrentEmployees].EmploymentStatus, [CurrentEmployees].WorkStudyAward, [CurrentEmployees].StartDate, [CurrentEmployees].EndDate, [CurrentEmployees].ReasonForEnd, [CurrentEmployees].ReasonForEndNotes, [CurrentEmployees].BackgroundCheckCompleted, [CurrentEmployees].CleryTrainingCompleted, [CurrentEmployees].NotificationSenttoHD, [CurrentEmployees].InstructionsSent, [CurrentEmployees].OfferSent, [CurrentEmployees].OfferAccepted, [CurrentEmployees].DateAdded, [CurrentEmployees].[Select]

FROM CurrentEmployees

WHERE ((([CurrentEmployees].[Select])=Yes));

Answer 1

Have you perchance changed the name of the EndDate field in either table recently? This might be a problem with the notorious Name Autocorrect feature (nicknamed "Name Autocorrupt" by some of us). If your database properties are set to "Track Name Autocorrect", try turning that feature off, compacting the database, and see if the query now works.

You may also want to try copying the SQL of the query out to a file; delete the query; compact the database and recreate the query by pasting the SQL back in. It's possible that the compiled version of the query is out of step with the SQL, though that would be unusual.