Re: adding information in an append
From: Ken Snell [MVP] (kthsneisllis9_at_ncoomcastt.renaetl)
Date: 12/29/04
- Next message: Access rookie: "Help on a complicated query!?"
- Previous message: Ken Snell [MVP]: "Re: Stupid question"
- In reply to: ESUguy: "adding information in an append"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 29 Dec 2004 14:31:46 -0500
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.
--
Ken Snell
<MS ACCESS MVP>
"ESUguy" <ESUguy@discussions.microsoft.com> wrote in message
news:ADE04C6C-45EB-4212-8C8E-7EA554509401@microsoft.com...
>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?
- Next message: Access rookie: "Help on a complicated query!?"
- Previous message: Ken Snell [MVP]: "Re: Stupid question"
- In reply to: ESUguy: "adding information in an append"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
