Unintended field "expression 1006" in the query grids

[Frank Situmorang]

Hello,

When I open my query, there is an unintended field "Expr 1006". I do not
know why is this automatically created. Anyone tells me, why this happened.

 

[Jeanette Cunningham]

Hi Frank
this usually means that you put the same field into the query twice.

Jeanette Cunningham

 

[John W. Vinson]

Hello,

When I open my query, there is an unintended field "Expr 1006". I do not
know why is this automatically created. Anyone tells me, why this happened.

You may have added a field from one of your tables to the query twice. Access
will create an alias for the second instance of the field.

If you want to see where it is, open the query in design view and select
View... SQL. You should be able to find "Expr 1006" in the query text
somewhere. If you're having trouble copy and paste the sql text to a message
here.

John W. Vinson [MVP]

 

[Frank Situmorang]

Thank you very much John, you enrich my knowledge