Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    35

    Unanswered: Expiration Notice

    Good Morning:

    I need to create a form that when I opening it a message show myself of all the persons that have in my tblPass whose ReturnDate of the material has expired. How I resolve these?

  2. #2
    Join Date
    Apr 2004
    Location
    Kingsland, Georgia
    Posts
    231

    Re: Expiration Notice

    "SELECT fldName FROM tblPass WHERE ReturnDate<NOW()"
    that SQL statement will work to select the data in the fldName field of the members whose dates are expired. of course, change fldName to whatever info you want back from the table. if you build that query then you can use the form wizard to make a form that pulls the data from the query and displays. lemme know if that wasn't what you were looking for.



    Originally posted by vilmarie85
    Good Morning:

    I need to create a form that when I opening it a message show myself of all the persons that have in my tblPass whose ReturnDate of the material has expired. How I resolve these?

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Minor bug:

    ReturnDate > NOW()"

Posting Permissions

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