Results 1 to 9 of 9
  1. #1
    Starmo is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2018
    Posts
    43

    Filter riws in query

    Hello peoples!
    I have one question I hope you will help me.
    How do I filter rows in my query, which are not needed but can be re-displayed if need.

    Kind regards!

  2. #2
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    If the query results are on a form, apply a filter. Either through VBA or using the right click menu options.
    Or specify criteria for the filter in the query design.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    Starmo is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2018
    Posts
    43
    Quote Originally Posted by Minty View Post
    If the query results are on a form, apply a filter. Either through VBA or using the right click menu options.
    Or specify criteria for the filter in the query design.
    Based on that query I made a report, is it possible to filter the rows in the report, which I do not need but can show them as needed.

  4. #4
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    You can filter a report in Report view mode, again by right clicking a field and applying a filter.
    This filter will be held over if you goto print preview.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  5. #5
    Starmo is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2018
    Posts
    43
    Yes, I understand. But I have a report of 35 names, some of which need not be displayed. The criterion is pulled from a completely different table where I made the column for those names "Active" - YES / NO.

  6. #6
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    In the report for the Query add the other table, link the matching field (Names?) and add the "active" field, make the criteria for that = Yes
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  7. #7
    Starmo is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2018
    Posts
    43
    Minty thanks for previous posts!
    Please consider that I am a beginner in access, can you explain me more closely, how to link a report with the required table and column.
    Thank you!

  8. #8
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Does this help ?
    Click image for larger version. 

Name:	Relationship.PNG 
Views:	11 
Size:	35.0 KB 
ID:	34483
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  9. #9
    Starmo is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2018
    Posts
    43
    Quote Originally Posted by Minty View Post
    Does this help ?
    Click image for larger version. 

Name:	Relationship.PNG 
Views:	11 
Size:	35.0 KB 
ID:	34483
    Much, I'm done. Thank you!

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

Similar Threads

  1. SQL Query Filter and SUM
    By Adsens in forum Queries
    Replies: 1
    Last Post: 02-25-2018, 01:49 PM
  2. Replies: 2
    Last Post: 02-20-2017, 11:28 PM
  3. Replies: 7
    Last Post: 05-27-2015, 12:45 PM
  4. Query, Look-up with filter?
    By CocoPuente in forum Queries
    Replies: 1
    Last Post: 10-08-2014, 11:00 PM
  5. Replies: 2
    Last Post: 01-30-2013, 07:34 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