Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Talking Unanswered: Look Up Renewals Dates in an Edit Parameters Form

    Hello Everyone and Merry Christmas

    I have a question I need my users to be able to enter a between statement into an Edit Parameters form I have created for them. The reason being is so that they can find out when employees are due for a renewal (which is every two years from their final suit date..for example if their final was done on 12/01/2006 then they would be due to renew 12/31/2008).
    The code below allows them to look up final suit dates of individuals. I would like them to look up Renewals based on final suits. like:
    Code:
    BETWEEN 12/01/2006 AND 12/31/2006
    . and get the results, does that make sense???



    Code:
    SELECT     TM#, LASTNAME, FIRSTNAME, CONDITIONAL, DATEOFCONDITIONAL, FINALSUITDONE
    FROM         dbo.EmployeeGamingLicense
    WHERE     (FINALSUITDONE = @Enter_FINALSUITDONE)

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Why not give them a drop down of the month and year, and then you calculate the date range needed in the proc?

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Hi tom

    What do you mean can you elaborate??

Posting Permissions

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