adding information in an append

[Guest]

I am making an append query and have 2 issues. First, I need it to show all
columns I select for the query, not just the fields being updated.

Second, I am building the query to update to a table that has 3 possible
values for a column, can I make the database show the list so I can chose
before it updates?

 

[Ken Snell [MVP]]

Append queries are not intended for displaying data. Your desire to "see"
all the columns is therefore an inappropriate desire for this type of query.
Use a Select query to display data.

As for the second question about displaying choices, the query won't do this
for you. Instead, use a form that is designed to show the data before
updating and let you select what you want to do, and then have the form's
programming run the query. This likely isn't a simple thing to set up,
though, if your ACCESS skills are not medium-level.