Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    BECCLES, Suffolk, England
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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?
    Attached Images Attached Images
    <IMG SRC=http://www.wopr.com/w3tuserpics/StephenElms_sig.jpg> Didn't think that I made my first post here on 5th February 2001...!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    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.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    BECCLES, Suffolk, England
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Spot on Hans, thankyou. But I do not know what changed the property from yes to no though!
    <IMG SRC=http://www.wopr.com/w3tuserpics/StephenElms_sig.jpg> Didn't think that I made my first post here on 5th February 2001...!

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    [quote name='StephenElms' post='797722' date='13-Oct-2009 18:11']But I do not know what changed the property from yes to no though![/quote]
    Perhaps a bit fell over...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •