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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

changing the context of a numeric field to a different format 1

Status
Not open for further replies.

quesnell

Technical User
May 14, 2003
4
0
0
GB
Hello

I am trying to change the way a numeric field prints on a report. the is in the odbc database as "123456,12345678" and I want it to be "123456 12345678". i.e the comma to be taken out and 2 spaces inserted.

Is it possible
 
Create a formula containing something like:

Replace({table.Field},","," ")

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top