Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2002
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Append Query Access 2000 (Access 2000)

    <P ID="del"><FONT SIZE=-1>Post deleted by tom</FONT>

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Append Query Access 2000 (Access 2000)

    To update a table you need an update query and not an append query.
    Add the cstlostmoney field to the table that haven't it.
    Create a query with the tblcustomer and tblthird.
    Set the relation to the key field.
    Add one field to the query : the one you add in the previous step.
    In the menu select Query | Update Query.
    In the new line Update To enter the existing cstlostmoney field.
    Run the query.

    Don't forget : make first a backup of you mdb.
    Francois

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •