Counting Characters

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stefan - 23 Nov 2005 21:58 GMT

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?

Signature

Thanks in advance
Stefan

Reply to this Message

fredg - 23 Nov 2005 22:06 GMT

> I need to create a field in a query which counts the number of characters in
> another field.
[quoted text clipped - 9 lines]
>
> How can I count everything but the blank spaces?

Len(Trim([Policy#]))

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Stefan - 23 Nov 2005 22:35 GMT

Thanks worked perfectly

Signature

Thanks in advance
Stefan

> > I need to create a field in a query which counts the number of characters in
> > another field.
[quoted text clipped - 11 lines]
>
> Len(Trim([Policy#]))

Reply to this Message

KARL DEWEY - 23 Nov 2005 22:36 GMT

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

> I need to create a field in a query which counts the number of characters in
> another field.
[quoted text clipped - 9 lines]
>
> How can I count everything but the blank spaces?

Reply to this Message