Results 1 to 7 of 7
  1. #1
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496

    Theory I hope to work with recordset and filtering another recordset

    I have a form with a list of schools however I want to filter any schools that have bookings for next year away from this list.

    I thought of using recordset by making an sql string, list all the bookings with criteria and then produce a list of schools that have those bookings.

    from that list I would then collect the IDs and use that to...



    filter any of the schools that match those IDs out of the list.

    Then after it is filtered I would go through that recordset and email each record. Since the schools that had bookings have been filtered out - they wouldn't be emailed.

    Is this possible, what functions/rules would have I have to learn and use?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    My first thought is to create a query that returned schools with bookings for the next year, then use the unmatched query wizard to compare that with the table with all schools. That should return the desired schools. Base your email recordset on that query.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Quote Originally Posted by pbaldy View Post
    My first thought is to create a query that returned schools with bookings for the next year, then use the unmatched query wizard to compare that with the table with all schools. That should return the desired schools. Base your email recordset on that query.
    compare?

    um...

    how?

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Have you tried the wizard?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Quote Originally Posted by pbaldy View Post
    Have you tried the wizard?
    never really delved into that area - but having a look into it now...

  6. #6
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Hey that works

    only now I have to figure out how to customize the first query, maybe make a form that replaces the query with the new criteria (the schools I want to exclude).

  7. #7
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Don't see the need for a form based on your description, but you know the app better than I.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Recordset Filtering
    By George in forum Access
    Replies: 9
    Last Post: 05-27-2012, 10:10 AM
  2. How to Select second Recordset from first recordset
    By FrustratedAlso in forum Programming
    Replies: 28
    Last Post: 05-10-2012, 05:45 PM
  3. Replies: 2
    Last Post: 03-08-2012, 12:59 PM
  4. create table filtering a recordset
    By JJCHCK in forum Programming
    Replies: 5
    Last Post: 09-27-2011, 01:11 AM
  5. Replies: 1
    Last Post: 11-13-2009, 03:03 AM

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