Unintended field "expression 1006" in the query grids

F

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.
 
J

Jeanette Cunningham

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

Jeanette Cunningham
 
J

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.
Click to expand...

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]
 
Top