To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67530 Issue #|67530 Summary|queries in queries: calculated fields don't work Component|Database access Version|OOo 2.0.3 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|fornarif
------- Additional comments from [EMAIL PROTECTED] Wed Jul 19 00:20:42 -0700 2006 ------- Let's say that I build a query in query and inside the II Level query I put a calculated field. All will work fine until the query will be closed and re-opened or the Query Design View will be switched off and again on. After both actions the II Level query won't work anymore, because Base modifies the calculated field, inserting in the "Table" line the name of a "normal" table. This behaviour can easily reproduced by the attached little sample database. Best regards, Franco --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]