Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    3

    Update Tables

    I need to update a table based on values in another table. In addition, I need to increment a value each time (the value that is updated in the second table.



    To accomplish this, I selected my records from my table into a new table.
    Then, I was going to use a WHILE NOT EOF statement to go through this temporary table, and update the records in the original table. However, I am having trouble scanning through this table using the while. I can't get the syntax to work. Can you give me ideas on how to do this, or the syntax to make it work?

    Thank you.l

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    Why are you going with this approach? This is basically storing calculated values in a database, which is a bad db practice.

  3. #3
    Join Date
    May 2006
    Posts
    3
    Auditor requires that we track license numbers. In a licensing process, these will be the license numbers.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. update tables via forms
    By jazoo in forum Forms
    Replies: 0
    Last Post: 09-16-2008, 05:54 AM
  2. Joining tables two tables and another table that is not
    By DevintheDude in forum Database Design
    Replies: 0
    Last Post: 09-12-2007, 08:56 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums