Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2002
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Designing a query in Access 2002 (Office XP, Version 2002)

    I created a query using the Simple Query Wizard. In Design view, I clicked to clear the check mark in the Show check box so the field would not display in the query results. I saved the query, then reopened it in Design view to make more modifications. I wanted to redisplay the field that I had hidden earlier, but it no longer appears in the design grid. Does clearing the Show check box actually delete the field from the query altogether? I thought it was only supposed to hide the field. Thanks for your help!

  2. #2
    brandonbiz
    Guest

    Re: Designing a query in Access 2002 (Office XP, Version 2002)

    Hi, If you don't have any criteria in that field and you un-check the show box, yes access will delete the field from the query. I think the reason it does this is because that field isn't needed.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Designing a query in Access 2002 (Office XP, Version 2002)

    It deleted it from the query grid and from the SQL behind it because you aren't using it. It's still in the table and you can drag it back onto the query grid if you need it.
    Charlotte

Posting Permissions

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