T
Ted Allen
You can use the built-in len() function to return the
length of a string. You can create a new field in a
query with the text length by just typing:
len([yourfieldname])
as the source in a blank column in the query design
grid. You can also use the function as a part of the
criteria for another field.
HTH, Ted Allen
length of a string. You can create a new field in a
query with the text length by just typing:
len([yourfieldname])
as the source in a blank column in the query design
grid. You can also use the function as a part of the
criteria for another field.
HTH, Ted Allen