How to create list of (unique) street names ?

  • Thread starter Thread starter Will
  • Start date Start date
W

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.
 
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.
 
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...
Click to expand...

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....
 
Thanks Allen. Worked perfect!

Allen Browne said:
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.
Click to expand...
 
Back
Top