Need to determine length of field for query

  • Thread starter Thread starter Barry
  • Start date Start date
B

Barry

I need to use a query that will show me in the address field all those
records where the address is longer than 35 characters. I want to be able to
shorten those to fit in a specific label. I can then use this syntax to also
abbreviate city names that are too long for the label
 
I need to use a query that will show me in the address field all those
records where the address is longer than 35 characters. I want to be able to
shorten those to fit in a specific label. I can then use this syntax to also
abbreviate city names that are too long for the label
Click to expand...

Create a query based on the table with a calculated field

AddrLen: Len([address])

Put a criterion of
35
Click to expand...

on this field to find all the verbose addresses.

Abbreviating the city might not be all that easy, unless you were to have a
table of city names and acceptable abbreviations; you may want to do these
manually if there aren't too many.
 
Back
Top