(Msg. 2) Posted: Tue Oct 27, 2009 2:54 pm
Post subject: Re: Creating a Select Query [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Tue, 27 Oct 2009 13:41:01 -0700, RollieG
<RollieG.RemoveThis@discussions.microsoft.com> wrote:
>Is it possible to create a Select Query in Access so that it affects (or
>changes) the data table or tables it uses for its results?
No, but a Select query can be editable in its own right, so that a user can
open it as a datasheet and change data; or (more appropriately) used as the
Recordsource for a Form which again can be used to edit data. The data will
indeed be changed in the underlying tables; the query has no independent
existance.
Not all Select Queries are updateable but most are, or can be made so.
--
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other