Yes, and kind of no. You can start with GUI functions and select your
fields and handle your joins. But then you must turn the designer off
and finish the part with the concatination by hand. Just so you know it
also means that you can enter it as more standard Accesseeze also, this
statement would be just as valid with SQL direct turned on
SELECT [FirstName]+ ' ' + [LastName] AS [Name] FROM [Customers]
By the way, the above select staetment is what is actually generated by
the MS Access query builder when you enter
Name: [Firstname] + ' ' +[LastName]
in the field area of the designer and sent to the Jet engine.
Because Base is a loosely coupled front end [i](My terminology
there)[/i] to any number of backends it is the syntax that is accepted
by the MS Jet engine that you need to enter, not the syntax you enter in
the MS Access GUI, since MS Access itself is just a front end to the Jet
engine, albeit a very tightly coupled front end.
This also means that once your make the final changes you can not turn
the designer back on, it will report a syntax error.
Shane Johnson wrote:
Thank you Drew. I will give that a try. Will have have to build the
whole query with SQL or can I just do the column I need to modify?
Thanks
Shane
Andrew Jensen wrote:
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]
---------------------------------------------------------------------
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]
