why is Expr1: [name] showing up in the field of my query

[coilerDH]

In the query design view I have some fields. Some of them are yes/no. But one says this, Expr1: [Inactive] in the field name. Its the only one that does that. "Inactive" is a yes/no and is a check box. Whats happening?
Thanks

[orange]

That is a default done by Access. If you want a different name, just add it to the query grid, or as an alias in the sql view of the query.

[June7]

Is the same field pulled into the query grid twice? Post the SQL statement of the query.

[coilerDH]

Its only listed once. I just noticed that if I use the query wizard, the "Inactive" field shows up normally.

[coilerDH]

I created a test query to post. Bolth are yes/no, added the same way.

SELECT [dbo_Client Table].[Inactive] AS Expr1, [dbo_Client Table].Archive
FROM [dbo_Client Table];

Why is the "inactive" doing that?

This test query done with the wizard
SELECT [dbo_Client Table].[Inactive ], [dbo_Client Table].[Archive], [dbo_Client Table].[DNQ]
FROM [dbo_Client Table];

[orange]

??? Don't have a direct answer.
But you can do this (remove the As Expr1)

SELECT [dbo_Client Table].[Inactive], [dbo_Client Table].Archive
FROM [dbo_Client Table];

[coilerDH]

Already tried to remove it. Doesn't save.

[orange]

Then you must have Inactive used somewhere else. Or at least Access thinks you have.

[coilerDH]

Thanks for responding. I m going to recreate the query using the wizard.