Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Unanswered: Copying a value from the same table

    Greetings all.

    I apoligize for the basic question, but I've been banging my head for days to no avail.

    I have a table "Collections" that stores a machine #, date of the collection, and a meter reading.

    I'd like to add a new field to the table called "last meter" which receives it's value automatically by looking up the last entry for the given machine # and stores it in this new field.

    Any help would be most appreciative.

  2. #2
    Join Date
    Nov 2003
    Posts
    267
    How are you planning on adding each new record?

  3. #3
    Join Date
    Nov 2003
    Posts
    3
    Originally posted by sbaxter
    How are you planning on adding each new record?
    New records are added via a form.

Posting Permissions

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