Results 1 to 5 of 5
  1. #1
    mithrilbus is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Apr 2016
    Posts
    5

    The query I want to access is not in the list of Expression Elements in the Expression builder

    I was assuming that the list of Expression Elements would be populated with every possible table, query etc, but the one I want to use is not there.



    How do I get it to show up?

    Thank you!


    Access 2013 32 bit
    Windows 7 Pro 64 bit

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I don't see how that's possible. it shows everything, but If you only want to add a table/query, then just use the SHOW TABLE button.

  3. #3
    mithrilbus is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Apr 2016
    Posts
    5
    I see no SHOW TABLE button, is there another UI that I can access?

    Click image for larger version. 

Name:	ExpressionBuilder.PNG 
Views:	12 
Size:	31.4 KB 
ID:	24515

  4. #4
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    In my dB, all tables are available, but only Select queries are displayed when I click on queries. Maybe check the table name.......

  5. #5
    mithrilbus is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Apr 2016
    Posts
    5
    That was it!!! Sorry I didn't reply sooner, I got very excited and started working! Thanks!

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

Similar Threads

  1. Query expression builder missing data
    By sangamc in forum Access
    Replies: 5
    Last Post: 09-16-2015, 01:46 PM
  2. Replies: 2
    Last Post: 03-22-2015, 11:16 AM
  3. Replies: 2
    Last Post: 11-20-2012, 03:21 AM
  4. expression builder: update query
    By JMac in forum Access
    Replies: 3
    Last Post: 05-04-2012, 03:19 AM
  5. Expression Builder in Access Reports
    By csland in forum Access
    Replies: 1
    Last Post: 08-22-2011, 08:00 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