Number of characters in a field...

  • Thread starter Thread starter Carlos
  • Start date Start date
C

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

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.
 
Back
Top