Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

MS Access Help


  • Please log in to reply

#1
swicklund

swicklund

    Member

  • Member
  • PipPip
  • 25 posts
I must be going brain dead.. :tazz:
I have a list of over 5,000 entries for various collage & professional sports teams. I would like to write a query to pull one entry for each team listed (If I have the Badgers listed 100 times, I only want one of those recored in the results).
Any suggestions??
  • 0

Advertisements


#2
Octagonal

Octagonal

    Member 2k

  • Member
  • PipPipPipPipPip
  • 2,528 posts
Hi swicklund,

Tell me if this is what you want to achieve.

From the table of teams(and data) that you have, you wish to write a query that lists each one of the teams only once (ie. to have a list of all teams).

Is this correct?

Octagonal

Edited by Octagonal, 14 March 2006 - 04:15 PM.

  • 0

#3
swicklund

swicklund

    Member

  • Topic Starter
  • Member
  • PipPip
  • 25 posts
Octagonal,

You've got it. That is exactally what I want to do..
  • 0

#4
Octagonal

Octagonal

    Member 2k

  • Member
  • PipPipPipPipPip
  • 2,528 posts
swicklund,

What you need to do is Group using Totals . I'll assume that you know how to create a query in design mode.

After you have selected the table that you wish to use as your recordset and selected which fields you require, select Totals from the View menu (or select the Totals button on the toolbar). Then select Group by from the drop down list in the Totals row. You can then select Ascending or descending from the Sort row as well.

Let me know if you still require help with this or if you aren't quite sure about creating a query.

Octagonal
  • 0

#5
swicklund

swicklund

    Member

  • Topic Starter
  • Member
  • PipPip
  • 25 posts
Octagonal,

Thank you! I had forgotten about the "Group By" option. Like I said, I was brain dead...
  • 0

#6
Octagonal

Octagonal

    Member 2k

  • Member
  • PipPipPipPipPip
  • 2,528 posts
swicklund,

Glad to be of help. :tazz:

Octagonal
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP