Results 1 to 3 of 3
  1. #1
    canast is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2012
    Posts
    2

    Expression builder does not show other query fields to add to an expression.

    Hiya



    I'm working on a query and trying to build an expression using the builder. My query has a number of fields that I need to use in an expression. I save the query (which should make these fileds available) and in a new field I open the expression builder. Sadly under the "Expression Categories" I don't see any of the query fields. Can you please let me know what I'm doing wrong?

    Tried to close the whole DB file, run a compact and repair and reopen but still the "Expression Categories" just displays <Parameters> and none of my query fields.

    Any insight will be appreciated. Thanks
    CA

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,481
    I don't use the expression builder. I just build expressions in query field or textbox.

    Want to provide db for analysis? Follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    canast is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2012
    Posts
    2
    Hi June7

    Thanks for your response. I think it was a matter of me keeping in the query some tables that were obsolete/were not used. Removing those resolved it.
    Thanks again!

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

Similar Threads

  1. expression builder: update query
    By JMac in forum Access
    Replies: 3
    Last Post: 05-04-2012, 03:19 AM
  2. Expression builder help
    By jigg14 in forum Forms
    Replies: 1
    Last Post: 03-19-2012, 09:47 AM
  3. expression builder
    By tonyl in forum Access
    Replies: 3
    Last Post: 11-26-2011, 12:00 AM
  4. Expression Builder or VB ... Help
    By Adynn in forum Access
    Replies: 0
    Last Post: 06-03-2011, 09:51 AM
  5. Expression Builder
    By mistaken_myst in forum Access
    Replies: 2
    Last Post: 05-07-2008, 01:30 PM

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 - Senior Forums