Creating a Select Query

  • Thread starter Thread starter RollieG
  • Start date Start date
R

RollieG

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?
 
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?
Click to expand...

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.
 
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

VBA - retrieve data on last create named range from previous inserted named range 0
Create table from a crosstab query 2
Select query w. DLookup => 2 secs., make-table version => 2 hrs. 3
Query from expression 2
Using select query results as filter for append query 14
Crosstab Query 1
Data Mismatch in Excel 2010 4
DLookup and Nz 0

Back
Top