Change a field in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After running my query, some of the fields will need to be changed. Is there
a way to (in a query that pulls from multiple tables/queries) allow changes
in a query field, or at least add a check box so I can make which ones will
need updating? Thanks!
 
After running my query, some of the fields will need to be changed. Is there
a way to (in a query that pulls from multiple tables/queries) allow changes
in a query field, or at least add a check box so I can make which ones will
need updating? Thanks!
Click to expand...

Data does not exist in Queries. Data exists in Tables, and *ONLY* in
tables.

Some queries are updateable, some aren't; but in any case, what you're
updating *is the data in the Table*, not in the query. All that the
query is is a view of data, selected fields and selected records; it
has no independent existance.

If you want to update your Tables, check the online help for
"updateable" to see if you can make your query such that it allows
updating; or, probably better, display your data on a Form (for the
"one" side) with one or more Subforms (for the related tables), and do
your updating on the Form.

John W. Vinson[MVP]
 
Back
Top