• Query Fields Display

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Query Fields Display

    Author
    Topic
    WSStephenElms
    AskWoody Lounger
    October 13, 2009 at 10:59 am #463147

    Office 2003 under W7RC1.
    Please review the attched screen shot. I have designed a query to just display 8 out of many fields. However when I switch from Edit to display, all the fields are displayed! Can anyone suggest a reason for this please?

    Reply | Quote
    Viewing 1 reply thread
    Author
    Replies
    • WSHansV
      AskWoody Lounger
      October 13, 2009 at 11:04 am #1181122

      Open the query in design view.
      Click in an empty part of the upper pane of the query design window.
      Activate the Properties window.
      Make sure that the “Output all fields” property is set to No.

      Reply | Quote
    • WSStephenElms
      AskWoody Lounger
      October 13, 2009 at 11:11 am #1181125

      Spot on Hans, thankyou. But I do not know what changed the property from yes to no though!

      Reply | Quote
      • WSHansV
        AskWoody Lounger
        October 13, 2009 at 11:15 am #1181126

        But I do not know what changed the property from yes to no though!

        Perhaps a bit fell over…

        Reply | Quote
    Viewing 1 reply thread
    Reply To: Query Fields Display

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    April 2025
    S M T W T F S
     12345
    6789101112
    13141516171819
    20212223242526
    27282930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.