Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi, I have a date on a table which defines when the clock starts ticking for a future deadline to be be met, say Ddate. From this is a query which has user input from a form. On that form the the default guage date is the current date, the user will input differing days in a text box, be it 7 days, 14 days, 21 etc. What I need this to say to the query is, take the Ddate and return any entries that are 7 days or more (14, 21, whatever the form input) from the current date and return those entires. How should I code this on the query criteria line?


    Many thanks, Darren.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Let's say that your form is named frmInput and that the text box is named txtDays.
    In the Criteria line for the DDate column in the query, enter the following condition:

    >=Date()+[Forms]![frmInput]![txtDays]

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='772131' date='24-Apr-2009 12:08']Let's say that your form is named frmInput and that the text box is named txtDays.
    In the Criteria line for the DDate column in the query, enter the following condition:

    >=Date()+[Forms]![frmInput]![txtDays][/quote]


    Thanks Hans, that simple? I feel foolish.

    Regards as ever, Darren.

Posting Permissions

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