Results 1 to 4 of 4

Thread: Form data

  1. #1
    Join Date
    Jun 2002
    Location
    Houston, TX
    Posts
    116

    Unanswered: Form data

    I am trying to create a form for input of a start and end date which populates the date field. Example in my query I could put a criteria
    >=#2/1/02# And <=#2/28/02#

    I want the form to change these values based on the user's input. Any help would be greatly appreciated.

    texasalynn

  2. #2
    Join Date
    Jun 2002
    Location
    Central New Jersey
    Posts
    69
    Base your form on a query. In the query criteria you would type:

    Between [Enter Starting Date] and [Enter Ending Date]

    This will prompt the user to enter a starting date, press ENTER, enter an ending date, and press ENTER again. Then the query will display the desired information.
    "There's never enough time to do it right, but there's always enough time to do it over!"

  3. #3
    Join Date
    Jun 2002
    Location
    Houston, TX
    Posts
    116
    Yes! Yes! Yes! that's exactly what I needed.

    texasalynn

  4. #4
    Join Date
    Jun 2002
    Location
    Central New Jersey
    Posts
    69
    You're welcome!!! :-)
    "There's never enough time to do it right, but there's always enough time to do it over!"

Posting Permissions

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