How to create list of (unique) street names ?

[Will]

We want a list of all the streets in our data base.

How can we create a list of individual street names in our data base?

We do not want the name of a street to show more than once on the list...

So I guess we want to do a query to find 'unique' or 'individual' street
names. (Or do we need a report built on a query?)

Thanks for any help.

 

[Allen Browne]

Assuming you have a field named Street in Table1:

1. Create a query using Table1.

2. Drag the Street field into the query grid.

3. Open the Properties box. Looking at the properties of the query (not of a
field), set Unique Values to Yes.

 

[(PeteCresswell)]

Per Will:

How can we create a list of individual street names in our data base?

We do not want the name of a street to show more than once on the list...

How are the street names stored?

If they're stored as just street names, that's one thing.

OTOH if they're embedded in peoples' street addresses, that's
another....

 

[Will]

Thanks Allen. Worked perfect!

Assuming you have a field named Street in Table1:

1. Create a query using Table1.

2. Drag the Street field into the query grid.

3. Open the Properties box. Looking at the properties of the query (not of
a field), set Unique Values to Yes.