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

How do I use one set of quotes as text? 1

Status
Not open for further replies.

mikefortune

IS-IT--Management
Feb 9, 2001
20
GN
How do I use just one set of quotes in a formula as a text item. For instance, I want 2 fields added together with a / between them and at the end of those fields I want a " added to that. Crystal keeps telling me the set is incomplete basically. Any ideas?
 
If you're using a formula field then all you have to do is tell crystal the values to insert between database fields.

Use the syntax

{database.field1} + " / " + {database.field2} to insert a slash symbol between two fields.

From personal experience I've had to use single quotes because double quotes are reserved for the above purpose. I'm afriad I don't pertain to be an expert, so if anyone knows differently I'd be interested to hear.
 
I actually found it. To get a single set of quotes in as part of text, it has to be four sets of quotes i.e.:
Field1+"/"+Field2+""""
That's the answer thanks!!!! all.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top