SQL. Delete a selection. Field persists.

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

Allen Browne

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete all data after a symbol in a field 0
Link a text box based on drop down box with four options MS Word 365 0
ASK Field Formatting 1
Query Question 2
bitwise operator in SQL 3
Update access table to sql table 1
Query keeps looking for Query1 field 3
determining if a field should be included 6

Top