SQL. Delete a selection. Field persists.

  • Thread starter Thread starter angbob
  • Start date Start date
A

angbob

In SQL View, I deleted a selection of the form
.[Field] AS EYear

Windows XP SP2
Access 2007

When I run the query, a pop-up appears, asking for the value of EYear.

While diagnosing, I deleted other stuff, e.g. a UNION. Then I restored my
original query without the EYear selection, and it worked, without asking for
EYear.

I haven't discovered a pattern. It has nothing to do with saving the query
or closing the database.

Has anyone seen this persistence of fields deleted from SQL?
 
A few things could cause this.

Is Name AutoCorrect turned off? Explanation:
http://allenbrowne.com/bug-03.html

Where the other occurances of EYear in the query statement (e.g. another
alias in another part of the UNION query?)

Was it in the query's properties? Particularly Filter or OrderBy?
 
Back
Top