Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002

    Unanswered: Updating a Table Column in A97


    I have a Table called Table 1 (assume) and that Table has a field called Rent. I use another Table, say Table 2 which has details of income and I need to insert the Rent values from Table 1 in fields called DUE1 , DUE 2, DUE 3 etc up to DUE 53 in Table 2 depending on the week number. Any suggestions of code to make this easy? The RENT may vary through the year so hence the need to update weekly into fields.


  2. #2
    Join Date
    Jun 2003
    I don't know but having fields DUE1 through DUE 53 doesn't sound like a very normalized table structure and thus would be have to develop with.

    For example, what would you do when the year suddenly switches?

    You might want to consider using a subtable or something with a date field perhaps.
    J. Paul Schmidt, Freelance Web and Database Developer
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

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