Query Output Format

[nancybrown]

I have an ID field that is a number field but is not currency. The ID field needs to return results with a () around the results and not "-". This field is uploaded into Quicken and then from there it is uploaded into another system; this other system will not accept the upload if it is not surrounded by (). I can use the expression below for my amount field and it returns the (), but since this is not a currency format for the ID, not sure how to write this. . . . How can I modify this query expression to return the following (example) results. . . . and yes, the field must be titled Memo even though it is a number field.

Memo: (Sum([ID])*-1)

Example: currently returns -12345; needs to return (12345).

Thank you.

 

[nancybrown]

Any takers?

 

[nancybrown]

I found a solution to this. . . when I export it to Excel, I'll just format it at that point.

 

[Micron]

Memo: "(" & (Sum([ID])*-1) & ")" ?
Would have to be a text field in order to allow parentheses