Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am trying to write an Open Report command with a where statement that excludes data. I am not sure how to write is so that when the status field says "Application Withdrawn" that record will not be included in the report. I have tried several variations of "Not" "Not =" "Is Not"

    DoCmd.OpenReport "rptLabels5961MSLSApplicants", acViewPreview, , "[Status] not 'Application Withdrawn'"

    Can someone help?

    Thanks.

    Paul

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    DoCmd.OpenReport "rptLabels5961MSLSApplicants", acViewPreview, , "[Status] <> 'Application Withdrawn'"

    or

    DoCmd.OpenReport "rptLabels5961MSLSApplicants", acViewPreview, , "not ([Status] = 'Application Withdrawn')"
    Regards
    John



  3. #3
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts
    <> worked.

    Thanks.

    Paul

Posting Permissions

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