Number of characters in a field...

[Carlos]

I have a database of records that include city name and street name. How can
I create a query to find out the number of characters for the longest name
appearing in each of the two fields.

Thanks in advance...Carlos

 

[John W. Vinson]

I have a database of records that include city name and street name. How can
I create a query to find out the number of characters for the longest name
appearing in each of the two fields.

Thanks in advance...Carlos

Create a Query based on your table. In a vacant field cell type:

CityMax: Len([City])

and in another

StreetMax: Len([Street])

using your actual fieldnames of course. Don't select any other fields.

Change it to a Totals query and replace the default Group By with Max under
these fields.