If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I sort Fieldnames
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! |
#2
|
|||
|
|||
How do I sort Fieldnames
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. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "KJMachado" wrote: 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! |
#3
|
|||
|
|||
How do I sort Fieldnames
On Wed, 15 Jul 2009 12:05:02 -0700, KJMachado
wrote: 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 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. -- John W. Vinson [MVP] |
#4
|
|||
|
|||
How do I sort Fieldnames
Thank you, John (and Jerry), for your response. That helped and I found my
Expr. =) "John W. Vinson" wrote: On Wed, 15 Jul 2009 12:05:02 -0700, KJMachado wrote: 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 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. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|