How do I sort Fieldnames

  • Thread starter Thread starter KJMachado
  • Start date Start date
K

KJMachado

How do I sort Fieldnames in a Query to locate a possible duplicate fieldname?
I am getting a field called Expr1027 when I display data but am not seeing
the Expr1027 in the design grid--did I drop a fieldname in the query twice or
what did I possibly do and how do I delete the unwanted field?

Thanks for any help!
 
The field names should display in the same order of the design grid when run.
The exception would be any that had the checkmark in the display box removed.
As there's a maximum of 255 fields in a query, and usually many less, you
should be able to find which one is the dupe and compare it to the other
fields.
 
How do I sort Fieldnames in a Query to locate a possible duplicate fieldname?
I am getting a field called Expr1027 when I display data but am not seeing
the Expr1027 in the design grid--did I drop a fieldname in the query twice or
what did I possibly do and how do I delete the unwanted field?

Thanks for any help!
Click to expand...

The easiest way for me when this happens is to go into SQL view; there'll be a
place in the SELECT clause with

, fieldname AS Expr1027,

It'll be a lot more visible there than in the grid.
 
Back
Top