Extract records from database

[KennyRohan]

I have a database for state of New York. One field in the database is "County". I would like to extract only 8 specific counties from this database. Is there a good procedure available to do this? Thank you.

 

[r937]

select distinct top 8 county from statetable

r937.com | rudy.ca

 

[fneily]

Create a query with your County field. Then in the criteria row under County put
In("County1","County2",etc.,"County8")

 

[dhookom]

Depending on why you want to do this and if you want to do something similar again, I might create a table of counties with the single field [County] as the primary key. Add the "8 specific counties" and use the county table with your existing table. When you join the county tables, only those from the 8 will display.

You could also add all unique counties to the table and add a yes/no field for selecting specific counties.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]