Make Table Query results in "Cannot Define Field More Than Once"

Question

I have a database of employees.  One field is Title.  In that field I have terminated for those employees that have left the company.  I want to do a make table query to put all the terminated employees in a new table.  I use the Tablename.* in the first column to show I want all fields.  In the second column I use Title and put "Terminated" in the Criteria field.  When I click on view it shows the terminated employees.  When I click on Run I get "cannot define field more than once".  What am I doing wrong?

Answer 1

Don't use Tablename.*  You can selec all the entries in the field list window and drag them all to the query field list to each field,  Then you can play around with the title field.

Answer 2

Uncheck the 'show' checkbox of the Title column in the query design grid.  This will build a WHERE clause in the query's SQL statement:

WHERE Title = "Terminated"

but will not include a specific instance of the column in the SELECT clause, so you won't get the duplication of the column name.

---

Ken Sheridan, Stafford, England