formating a text value

[Rodolfo Fontes]

Hi group,

I have a querie that list the products name from another table.
In the querie, products like "PC COMPUTER", that have 11 caracters, should
appear like "PC COMPUT", with 9 caracters.
And products like "PC", should be like "0000000PC".

How can I do that?
i've tried:
NAME: format([Product]; "000000000")
but it looks like only works on numeric values.

Thanks for any help,
Rodolfo Fontes

 

[Guest]

Not so sure about the meaning of the second part of your post, but if you
want just the first 9 characters to display in your query you can:

Name: Left([field],9)

Hope this helps
JMorrell

 

[Andi Mayer]

Hi group,

I have a querie that list the products name from another table.
In the querie, products like "PC COMPUTER", that have 11 caracters, should
appear like "PC COMPUT", with 9 caracters.
And products like "PC", should be like "0000000PC".

How can I do that?
i've tried:
NAME: format([Product]; "000000000")
but it looks like only works on numeric values.

replace(format(left([Product],9), "@@@@@@@@@")," ","0")