Fields change location when query chnaged to append

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

Guest

Since upgrading to Office 2003, I notice that in one of my append queries a
particular field moves to the end and data is not displayed when run. If I
move the field to where desired it will not save when run and it moves back
to the end again. However, when changed to simple query that field and data
remains. This has only happended since upgrading. Help?!
 
Since upgrading to Office 2003, I notice that in one of my append queries a
particular field moves to the end and data is not displayed when run. If I
move the field to where desired it will not save when run and it moves back
to the end again. However, when changed to simple query that field and data
remains. This has only happended since upgrading. Help?!
Click to expand...

Could you explain a bit more? Action queries, such as Append queries,
aren't designed to display anything! Running the query appends the
data to another table, and that's it - the datasheet view that you can
get to from design mode shows the records *which will be appended* as
a convenience for debugging, but that's it.

Perhaps this field doesn't have anything in its Append To property?

If you could post the SQL view of the query someone might spot what's
wrong!

John W. Vinson[MVP]
 
Back
Top