Hi shane,
Using OO 2.0.1 on WinXp and connecting to a MS Access database I can
perform a cancatination such as this:
SELECT `FirstName` & ' ' & `LastName` AS 'Name' FROM `Customers` `Customers`
You must run this query as 'Run SQL Direct', which in the Query builder
is the button with a green check mark over the letters SQL.
HTH
Drew
Shane Johnson wrote:
Good Afternoon. I was referred here from the OOo users group.
The following is a paste of the message I sent to that list. If
anyone can help me I would appreciate it.
Thank you
Shane
I am converting from Access to Openoffice and was trying to run a query
against a ODBC source. In Access I could do something like the
following
fieldname: [table:Data1] + [table:Data2}
and have it spit out a concatenated result. I tried this in Base and it
will not let me do this. Did I miss something or is there a different
way to do this.
I am running 2.0.1 on Win2K.(Let me know if you need more info)
I went through the how-to on Base and it didn't really help. If there
is some other resource you could point me to that I couldn't find, that
would be appreciated as well.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
