Page
|
|
|
Next Page |
|
| Contents > Creating a database > Working with formulas and functions > Adding a new line to the results of a formula |
|
|
| Adding a new line to the results of a formula |
| You can format the results of a formula by inserting carriage returns in your calculation. |
| To add a new line to the results of a formula: |
| 1. | With the database open, choose File menu > Manage > Database. |
| 2. | In the Manage Database dialog box, click the Fields tab. |
| 3. | If your database contains more than one table, select the appropriate table from the Table list. |
| 4. | In the Fields tab of the Manage Database dialog box, select the calculation field, then click Options. |
| 5. | In the Specify Calculation dialog box, click to insert the cursor in the place you want the line to break. |
| 6. | Click the ¶ button (carriage return operator) to insert a line break. |
|
|
See Defining calculation fields for information about the dialog box. |
| 7. | Click OK. |
| Note Type \¶ (backslash followed by a carriage return operator) to enter a carriage return (paragraph) symbol instead of an actual line break. |
| Examples |
| Field1 & ¶ & Field2 returns: |
Fred |
| when Field1 contains Fred and Field2 contains Jane. |
| "Fred ¶ Jane" returns: |
Fred |
| Related topics |
|
About formulas |
|
About functions |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
Text operators |
|
Using operators in formulas |
|
|
| Contents > Creating a database > Working with formulas and functions > Adding a new line to the results of a formula |
|
|
Next Page |
|