Need a String Format

[Mota]

Hi;
I want to get just the 4 letter of a string having more than 4 letter. i.e
getting "8405" from a "840501" string.How would be its format string?
Thank you in advance for ur help.

 

[Rick B]

Left([SomeField],4)

 

[Mota]

Can it be done thru Format() Function?
thank you.

Left([SomeField],4)


--
Rick B

Hi;
I want to get just the 4 letter of a string having more than 4 letter. i.e
getting "8405" from a "840501" string.How would be its format string?
Thank you in advance for ur help.

 

[Rick B]

I don't know. Why not just use what I gave you?

Simply create an unbound text box, enter the text I gave you, and you'd
done!


--
Rick B

Can it be done thru Format() Function?
thank you.

Left([SomeField],4)


--
Rick B

Hi;
I want to get just the 4 letter of a string having more than 4 letter. i.e
getting "8405" from a "840501" string.How would be its format string?
Thank you in advance for ur help.

 

[t t via AccessMonster.com]

you can do it using format() as like ;
format(val(left([field],4)),"0000")

 

[Mota]

Ok,thank you so much for ur help.

I don't know. Why not just use what I gave you?

Simply create an unbound text box, enter the text I gave you, and you'd
done!


--
Rick B

Can it be done thru Format() Function?
thank you.

Left([SomeField],4)


--
Rick B



Hi;
I want to get just the 4 letter of a string having more than 4

letter.
i.e

getting "8405" from a "840501" string.How would be its format string?
Thank you in advance for ur help.