Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Location
    UK
    Posts
    233

    Unanswered: Populate one field from a caluculation of another

    Populate another field from a calcuation of another field.

    I have a database designed for hotel bookings. What I want to do is when the user enters the starting date of the stay "say 01 Jan for 7 nights it automatically calcuates the last night as the 7 Jan" and populates this field from a form, and shows that information in the form.

  2. #2
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    afterupdate event of the startdate field use the following syntax

    myendatefield = mystartdatefield + 7

Posting Permissions

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