Field out of position

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have parsed a YYYYMMDD field (from an SQL db, via ODBC) to display as
mm/dd/yyyy using a combination of 3 Mid functions and concantenating. It
works fine. I then moved the field to the far left column so it appears at
beginning of record. However, the design window indicates it should be first,
but it appears in the datasheet view at the end of the record (where I
originally constructed it). How can I make it relocate to first field
displayed?
 
twinspar said:
I have parsed a YYYYMMDD field (from an SQL db, via ODBC) to display
as mm/dd/yyyy using a combination of 3 Mid functions and
concantenating. It works fine. I then moved the field to the far left
column so it appears at beginning of record. However, the design
window indicates it should be first, but it appears in the datasheet
view at the end of the record (where I originally constructed it).
How can I make it relocate to first field displayed?
Click to expand...

Either copy your SQL, delete the query and then rebuidl it byu pasting the
SQL inot a new query or just select the column in datasheet view and drag it
over there.

Mind you where you SEE a column when looking at a datasheet from a query is
prety meaningless.
 
Back
Top