Results 1 to 3 of 3
  1. #1
    EngineerGuy is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    1

    Qurries and Display Values

    Hello All,



    I have been following the Microsoft instruction located at: https://support.office.com/en-us/art...mk_search_text. I have a question about something peculiar that happens when following their example.

    I begin with a table called signals. It has an designation field, a from field, and a to field. When I create a query, and drag the fields to the query properties it creates a list of everything in that table as I would expect.

    What I don't understand, is when I drag a second table onto the field, "Equipment" I get nothing when I run my query. Why do I get blank results when I drag that second table into the query even tho the query properties are exactly the same?

  2. #2
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    377
    How are the two tables connected? Hmm, might help if you post the SQL of the query.

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    That link is for queries against multi value fields. I doubt the sql will reveal that. I would say that the best advice is to get rid of your multi value fields if that's what's involved here. They will only make things harder for you.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Counting values then display the sum
    By shod90 in forum Forms
    Replies: 1
    Last Post: 03-04-2016, 05:23 PM
  2. Replies: 19
    Last Post: 09-09-2014, 01:36 AM
  3. Replies: 18
    Last Post: 04-16-2014, 11:45 AM
  4. Display rows where column values are the same
    By tomseattle in forum Queries
    Replies: 1
    Last Post: 07-30-2013, 12:44 PM
  5. Replies: 1
    Last Post: 03-27-2010, 06:13 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
  •  
Other Forums: Microsoft Office Forums