To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97638 Issue #|97638 Summary|No way of entering formulae into data fields Component|Database access Version|RPT 0.5.0.20070627 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|SRB Assigned to|dbaneedsconfirm Reported by|ptoye
------- Additional comments from pt...@openoffice.org Mon Dec 29 11:56:45 +0000 2008 ------- There appears to be no documented way of entering formulae into data fields. Whatever I type comes up with a blank result. Specific example: With query fields Location and Type (each VARCHAR) I want to output a single string of Location followed by a colon followed by the type. None of the folowing work: Location & ': ' & Type Location || ': ' || Type Location + ': ' + Type and similar ones with the field names enclosed in double quotes. What is the syntax please? --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org