Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Write a query (XP)

    Just learned this was even possible - can't find a thing on how to CREATE a query in Excel - can only find info on how to change an existing one.

    Help, please.

    Aunt Linda

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Write a query (XP)

    Try Data | Get External Data | New Database Query...

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Write a query (XP)

    Ahhhhhhhhhh - I get it now - I thought Excel had some sort of feature similar to a query in Access that would "query" data in an Excel worksheet - which I didn't see the need for and didn't understand - I think I've got the drift, now.

    Cheers

    Aunt Linda

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Write a query (XP)

    The nearest equivalent to an Access query in Excel would be AutoFilter and Advanced Filter (both under Data | Filter). You can use them to select "records" (rows) from a table satisfying some criteria.

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Write a query (XP)

    Both of which I use all the time which is why I didn't understand the need for a "query" . . . . now I know one more thing I didn't know when I got up this morning - always a good thing!

    Thanks again

    Aunt Linda

Posting Permissions

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