Length of Text

[TeeSee]

I have a text field with 4,5 or 6 character text content. In a query,
how can I extract all records with a length of 4 and then add 6
leading zeros to it

Thanks

 

[J_Goddard via AccessMonster.com]

For a select or update query?

Add an expression field to the query which has len(trim([MyField])) as the
expression, and 4 as the criteria.

Then add another expression field, with the expression as "000000" & [MyField]


If you are using an update query, the "000000" & [MyField] will go in the
Update To row for [MyField].

HTH

John

 

[TeeSee]

For a select or update query?

Add anexpressionfieldto the query which has len(trim([MyField])) as theexpression, and 4 as the criteria.

Then add anotherexpressionfield, with theexpressionas "000000" & [MyField]

If you are using an update query, the "000000" & [MyField] will go in the
Update To row for [MyField].

HTH

John

I have a textfieldwith 4,5 or 6 character text content. In a query,
how can I extract all records with a length of 4 and then add 6
leading zeros to it

Thanks

Never understood the expression field until now. Many Thanks indeed!