[swicklund]

I must be going brain dead..
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??

[Advertisements]

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.

[Octagonal]

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.

[swicklund]

Octagonal,

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

[Octagonal]

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

[swicklund]

Octagonal,

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

[Octagonal]

swicklund,

Glad to be of help.

Octagonal