Re: update all records in table

Tech-Archive recommends: Fix windows errors by optimizing your registry

I like the idea of adding a column to the table. Sounds very simple!

How do I populate each record with the same value? Will it differ if I use a
numeric value or a text value?



Michel Walsh wrote:
You need a data definition language statement, or, much simpler, use the
table design and add a column to your table.

An update query can only modify values. It does not change the structure of
the table(s).

Vanderghast, Access MVP

I have a table that contains 80,000 records and want to add a field that I
can use to note year and location of receipt of record.
[quoted text clipped - 5 lines]

thanks in advance!

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Re: How do I populate a form with the data from a previous order ....
    ... Vanderghast, Access MVP ... >I want to enter a surname in my form and populate other fields in the form ...
    (microsoft.public.access.forms)
  • Re: Table Value Update with Value in Another Table
    ... to generate the corrective action plan, ... to populate the area of work in the second table. ... Doug Steele, Microsoft Access MVP ... using an update query and set value as a macro. ...
    (microsoft.public.access.forms)
  • Re: Default Values within fields
    ... <Access MVP> ... The,"In", may differ from file to ... >> Jeff Boyce ... >>> Hangnail ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Default Values within fields
    ... The,"In", may differ from file to file. ... Hangnail ... "Jeff Boyce" wrote: ... > <Access MVP> ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Find record if not add record
    ... Vanderghast, Access MVP ... > This may sound dumb and I should be able to do this, ... > compare the fields against the queries record set. ... > have it populate the rest of the form if not then go to new record. ...
    (microsoft.public.access.formscoding)