How to update data which has been extracted from a table ?

[w860098]

I have a table with a large number of fields (created from an external spreadsheet) and I need to select some of those fields using a query.
Having extracted that data, I wish to add an additional field to that data list and be able to update the contents of the new field.
Currently I am achieving this by exporting the results of the query and then importing that data as a new table (and then having to define the new field). I have then generated a form to provide online update facilities for that table
This is not an ideal approach. Can anyone suggest a better method of being able to updating data which has been extracted by a query ?

 

[psemianonymous]

The simplest way to add fields is to open the table in design view and manually add field(s).

Then, store all your calculations in this new field by using an "Update Query".


If you do this sort of thing often and want to automate the process, search the help for the SQL statement "ALTER TABLE", which can add one field to the table each time it is run. This means you can run this SQL statement, pulling the new fieldname and field type from controls on a form.