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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query field names changing to expr#: 8
Append query - Append to table with Autonumber field 2
Access 2010 append query to SQL is very slow 0
Appending null data and moving! 4
Data changes in append query 1
AutoNumber Field Not Populating with Append Query 2
Appending zero-length string 3
Date update in append query 6

Back
Top