Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2003
    Location
    Harrogate, Yorkshire, England
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Asterisk in queries (2000)

    Hello any Access gurus, can you help with this one? When creating a query from scratch and adding a table, what is the significance of the asterisk that appears at the top of the list of field names to drag onto the query below? Will be training this shortly, so don't want a whole heap of misinformed users out there!

    Thanks

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

    Re: Asterisk in queries (2000)

    The * stands for "all fields". If you drag the asterisk to the grid below, and switch to datasheet view, you will see that all fields from the table are displayed in the query. A lot easier than dragging each individual field to the grid. Of course, you should use this only if you need to include all fields.

  3. #3
    Star Lounger
    Join Date
    Mar 2003
    Location
    Harrogate, Yorkshire, England
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Asterisk in queries (2000)

    Thank you Hans - that was easy! I'll try and think of a harder one next time ;-)

Posting Permissions

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