Re: RE: [users] Multiply 2 fields in Base Query
Frank Schönheit - Sun Microsystems Germa ny <[email protected]>
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Message-ID | <[email protected]> |
Hi Gert, >>I found that it is possible, see quotes below. What I can't find (and I >>promise I have googled, KBed and Manualed it to death), is what the correct >>syntax is, either in SQL View or Design View, i.e. how do I present the >>FIELD1 * FIELD2 (like in Access it was [FIELD1] * [FIELD2]). Any suggestions >>where to start looking? (Of course I don't know the version numbers, but >>they mention that in the latest version the "have improved it", so in some >>form it must have been there for a while. What's wrong with SELECT "FIELD1" * "FIELD2" FROM "TABLE"? Works perfectly for me. If this is not what you need, please elaborate. Ciao Frank -- - Frank Schönheit, Software Engineer [email protected] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -