Access 2010 Query Column Heading Showing Expr####

[MPXJohn]

Hopefully someone can help with this as I have been unable to find a solution. I have a query built off a table that is giving me column headings with the format Expr followed by 4 numbers. "Expr####". They are just text fields, no expressions, no calculations, no criteria. It is only happening to some of them.

[pbaldy]

If they aren't expressions, I'd guess the field is included in the SELECT clause more than once.

[MPXJohn]

That was it. Went to SQL and there they were. Twice. Deleted one and is working fine now. Thanks.

[pbaldy]

No problem. Done the same thing myself.