+ Reply to Thread
Results 1 to 9 of 9

Using "Or" between filters

  1. #1
    Registered User
    Join Date
    03-08-2012
    Location
    Notts
    MS-Off Ver
    Excel 2010
    Posts
    71

    Question Using "Or" between filters

    This is an MS project related question,- I know this is an excel forum, but I have always found excellent vba help here compared with other sites.

    I have 3 sets of filters I want to apply, with or functions in between. I have no problem with writing the filter code, its the "Or" code between filters im struggling with.

    Currently I have:

    Please Login or Register  to view this content.
    Then I need "OR"

    Please Login or Register  to view this content.
    Another "OR"

    Please Login or Register  to view this content.
    So in words, I want it to filter for 3 types of tasks:

    All tasks in that start this week and do not equal 100%
    or
    All tasks that finish this week and do not equal 100%
    or
    All tasks that are Late and do not equal "on schedule"


    Does anyone have any ideas how to replicate this filter in code?
    Last edited by mtt23; 10-26-2012 at 06:30 AM. Reason: code mistake

  2. #2
    Registered User
    Join Date
    03-08-2012
    Location
    Notts
    MS-Off Ver
    Excel 2010
    Posts
    71

    Re: Using "Or" between filters

    unless and function could be used instead?

  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Using "Or" between filters

    Your 1st and 2nd code snippet is the same. Have you missed out something?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  4. #4
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Using "Or" between filters

    You can ask a moderator to move this to the Access subforum. You might be able to get better advice there as Access pros might be monitoring that section more that the full forum for Access-related queries.

    Sorry I couldn't be of more help.

    abousetta
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  5. #5
    Registered User
    Join Date
    03-08-2012
    Location
    Notts
    MS-Off Ver
    Excel 2010
    Posts
    71

    Re: Using "Or" between filters

    Ahh, my mistake, the second code snippet field name should be "Finish" instead of "Start"

  6. #6
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Using "Or" between filters

    Thanks Abousetta, thread moved.

    Mtt23,

    I have never worked with access programming, so i have moved your thread over there where the experts can help you out.

  7. #7
    Registered User
    Join Date
    03-08-2012
    Location
    Notts
    MS-Off Ver
    Excel 2010
    Posts
    71

    Re: Using "Or" between filters

    As stated at the beginning of the thread, it is a MS Project releted query, and I cannot find a section on project. I wasnt sure acess would be any more help.

  8. #8
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Using "Or" between filters

    I don't know or use MS Project, but I found this and hopefully it explains your issue.

    http://officetechsupport.wordpress.c...oject-filters/

    Alan
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  9. #9
    Registered User
    Join Date
    03-08-2012
    Location
    Notts
    MS-Off Ver
    Excel 2010
    Posts
    71

    Re: Using "Or" between filters

    This webpage has been helpful; I think I have found a new direction to sovle my problem.
    Thanks Alan

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1