Results 1 to 4 of 4

Search multiple value from a query in a field of another query

  1. #1
    6cams is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2017
    Location
    Barcelona
    Posts
    1

    Search multiple value from a query in a field of another query

    Hello everyone,



    I'm new here and usually I found my answer in previous post...but not this time so I hope that I didn't miss anything!
    I'm not a programmer and my level of access is very low so...sorry if my question looks trivial .
    Below, my issue:
    I've done a query which gives me several results (basically, a list of email address).
    I would like to search this specific list of value in a specific field of another query. This field is a text, and these values could be display wherever in the field (at the begining/end/middle of the field).
    I've try to do it with the formula Instr but I don't know how to put the field of my previous query as a variable in the formula...and I have no idea how to do it taking another path.

    Any idea ?

    By the way, sorry for my english....I'm french.

    Thanks for your answer !
    Camille

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Can you show us a sample of what you expect to see? Is it that you have a list of email addresses and you are trying to find those email addresses in the other text field?

  3. #3
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,240
    Is there a key field that links the 2 queries? Can you post a sample of the data from both queries and what you want it to look like.

  4. #4
    WesHarding is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2017
    Posts
    60
    I believe I have done something similar, but as said above could you please post a sample of what you would like it to look like?

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

Similar Threads

  1. Replies: 1
    Last Post: 11-30-2016, 03:41 AM
  2. Replies: 8
    Last Post: 09-02-2015, 03:00 PM
  3. Query form multiple search in 1 line
    By trident in forum Queries
    Replies: 2
    Last Post: 04-01-2015, 03:41 AM
  4. Replies: 1
    Last Post: 03-20-2015, 03:19 PM
  5. Query that would search multiple critera and delete
    By justinwright in forum Queries
    Replies: 2
    Last Post: 08-25-2010, 10:05 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums