Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jun 2003
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    20
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Continuation to database query question

    Okay. A while ago I posted that I needed a date field in a query to find dates that were more than 90 old. That was accomplished with <Now()-90 for the opening date field. Now I want to add the additional criteria that the close date (diferent field) be empty. Using the null command presents a blank report. How can I make one field to be less than 90 days and the other only show the record when it's empty and other field is older than 90 days.

  2. #2
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post
    Check your SQL WHERE clause:
    Code:
    WHERE (([OpenDate]<Now()-90) AND ([CloseDate IsNull]))
    Alan

  3. The Following User Says Thank You to MacroAlan For This Useful Post:

    lockwoodbf (2011-03-07)

  4. #3
    New Lounger
    Join Date
    Jun 2003
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    20
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks that works with the only difference I did in the criteria for each field in query

Posting Permissions

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