Results 1 to 6 of 6
  1. #1
    MiaAccess is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2011
    Location
    Texas
    Posts
    31

    Show only active jobs determined by a date JobEndDate field

    I am trying to set the query to only show job without an end date. Is null does not work. I feel I should know this but I am stuck.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    IIf ([YourEndDateField] & "") = "")
    ...which covers both Null and ZLS

  3. #3
    MiaAccess is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2011
    Location
    Texas
    Posts
    31
    No that is not it, I only need to show jobs where the Enddate is not empty, thereby elimination closed jobs.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I'm confused. In post #1 you say "show job without an end date" and now you say "where the Enddate is not empty". Which is it?

  5. #5
    MiaAccess is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2011
    Location
    Texas
    Posts
    31
    Sorry, you are right, where the enddate is empty.
    Today is another day and it decided to work for me. The criteria for enddate now accepts: is null
    and now shows only open job.

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    So is this thread ready to be marked as Solved?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 08-25-2016, 04:19 PM
  2. show display name form active directory
    By sdel_nevo in forum Programming
    Replies: 1
    Last Post: 07-29-2014, 09:59 AM
  3. Show employee's booked jobs in a calendar view
    By 11Edward23 in forum Forms
    Replies: 2
    Last Post: 01-06-2014, 08:51 PM
  4. Replies: 1
    Last Post: 01-06-2014, 01:05 PM
  5. Replies: 3
    Last Post: 11-23-2013, 05:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums