Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    35

    Unanswered: Date filtering syntax

    I have a filtering condition on a report that is not working. The intent is to identify those records that have a value entered into the datestart field but doesnt have an entry into the DateEnd field yet. The filter below is being applied in the report properties filter section.

    [ReqFinanceDateStart] <> null AND [ReqFinanceDateEnd] = null

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Maybe try instead:

    Not IsNull([ReqFinanceDateStart]) and IsNull([ReqFinanceDateEnd])
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Jan 2006
    Posts
    35
    That did it Missingling
    Thanks!

Posting Permissions

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