pierrick:
You said:
peirrick wrote:I'm linking to a MsAccess database, I can see the table, I can see the data.
Since, OpenOffice BASE, in your case, is using the database syntax of MsAccess . . . correct syntax to use would be:
Code: Select all
SELECT `Col1` + `Col2` AS `Col3` FROM `Table1`
Let me attempt to explain what is happening in the background . . . between OpenOffice Base and MsAccess. IF, you write your query in the GUI ( Graphical User Interface ) . . . for example . . . from
Create Query in Design View... . . . Base will take the Query and put it through the 'parser' ( including checking for any Parameter Input . . . see the Base Help File ) to confirm the SQL syntax is 'valid'.
BUT, if you need to send some SQL 'directly' to MsAccess . . . withOUT Base checking the syntax ( for instance . . . if you are using some MsAccess function(s) that Base does not recognise ) . . . this CAN be done. That way, if the SQL is understood by MsAccess . . . it WILL work. The above is accomplished from the menu . . .
Edit -> Run
SQL command directly...
MUST HAVE A CHECK MARK
So, in your case . . . MsAccess does NOT recognise CONCAT . . . BUT . . . in order to concatenate fields ( columns ) . . . use a plus . . .
+ . . . so . . . if you wanted to put an additional space between the values . . . it would look like . . . `Col1` + ' ' + `Col2` AS `Col3` AND with
Edit -> Run
SQL command directly...
MUST HAVE A CHECK MARK . . . this WILL work.
I hope this helps, please be sure to let me / us know.
Sliderule
Thanks to add
[Solved] in your first post title (edit button) if your issue has been fixed / resolved.