Make Table Queries adding extra fields

Question

I have created a simple Make table query but when i run it extra fields are adding on the new table. 

The new table that i am creating takes certain fields from an existing table, then I have added additional columns which i want either to be blank or have  a predefined value. e.g. Product Class:"" and separate column Product code:"aaaa". (Once the new table is created i will update these fields using update query).

The problem is when i run the query I get the column i expect, but in addition in in query design i have two columns with "" and "aaaa" , i have used make table query many time before and never had this problem. Can anyone shine some light - thanks

Answer 1

As Hans asks, please post the SQL view of the query. We can't fix what we can't see!

But I have to ask - WHY are you routinely running MakeTable queries AT ALL? They're very rarely needed in a production database.  If you're creating a new table for each product or for each product class, that's a pretty serious misuse of how Access works. In a Spreadsheet you would often create a new Page for a new set of data, but not in Access! You would instead have all the data in ONE table and use a Query to select the needed subset of the data. Am I misunderstanding your process here?

Answer 2

Could you switch to SQL view, copy the SQL statement that you see, and paste it into a reply here? Thanks!