Counting Characters

[Guest]

I need to create a field in a query which counts the number of characters in
another field.

I have Len([Policy#])

The problem is this is a linked table from another database (advantage).
The field itself is always 20 characters. So if there are 12
characters(alpha numeric) in the policy number the program defaults 8 blanks
spaces at the end.

So all Policy# are returning 20 characters.

How can I count everything but the blank spaces?

 

[fredg]

I need to create a field in a query which counts the number of characters in
another field.

I have Len([Policy#])

The problem is this is a linked table from another database (advantage).
The field itself is always 20 characters. So if there are 12
characters(alpha numeric) in the policy number the program defaults 8 blanks
spaces at the end.

So all Policy# are returning 20 characters.

How can I count everything but the blank spaces?

Len(Trim([Policy#]))

 

[Guest]

Thanks worked perfectly
--
Thanks in advance
Stefan

I need to create a field in a query which counts the number of characters in
another field.

I have Len([Policy#])

The problem is this is a linked table from another database (advantage).
The field itself is always 20 characters. So if there are 12
characters(alpha numeric) in the policy number the program defaults 8 blanks
spaces at the end.

So all Policy# are returning 20 characters.

How can I count everything but the blank spaces?

Len(Trim([Policy#]))

 

[Guest]

Use Len(Replace([Policy#]," ","")) to remove spaces before counting.