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

Surrounding fields with quotations

Status
Not open for further replies.

AMS100

Programmer
Oct 19, 2001
111
GB
Our report needs to display all data with " , to define the stop and start of a field. ie. within the database the field may be stored as 123456 but I need to have crystal display it as "123456". I've tried using formula fields but not sure how to enter this, as crystal uses the " too. Thanks very much.
 
Hi AMS100,
Try creating your formula (for numeric and string fields) as:

'"'&{Table.FieldName}&'"'
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top