Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Okay, this isn't hard 1

Status
Not open for further replies.

jaburke

Programmer
May 20, 2002
156
US
Hi...
I have a field that looks like this:

489C

It's defined as a 6 char field, so it's actually '489C '. I want to make it ' 489C'. Help me with a formula to do this. I don't want to just do it in the formatting because I want to use ' 489C' in another formula. I know this isn't hard, but I'm going in circles.

Thanks!!
 
Right(" " & left((mytable.myfield}, instr({mytable.myfield}, " ")-1), 6)
 
Try this

Code:
space(6-length(trim({table.field})))+trim({table.field})

-lw
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top