[libreoffice-users] Need help to "translate" mdb file in odb

Hello,

I have a mdb file and i want to use it with LibreOffice so I need to 
"translate" all the macro, form ... for LibreOffice.

But i have some difficult to do it.

For example, how to concatenate 2 field in my SQL Request.


I have tried :

- [NAME] + [FIRSTNAME] , ok but i need an espace
- [NAME] + " " + [FIRSTNAME] , doesn't work
- LTRIM( coalesce( "NAME", '' ) || ' ' || "FIRSTNAME" ) , doesn't work
- "NAME" || ' ' || "FIRSTNAME", doesn't work
- CONCAT( [NAME], [FIRSTNAME] ), doesn't work

How i can make it ???

Thanks for your help.

If someone could help me to "translate" the file, it would be nice

Sincerely,

Jean Milot

--
Jean Milot - Directeur Technique
jmilot@dotriver.eu - www.dotriver.eu

24 b rue Baldassini, F-69007 Lyon
Fixe: +33 (0)4 2746 39 80 Direct: # 87  Hotline: # 89  Fax: # 81
Mob: +33 (0)6 68 15 58 17

DotRiver sur Euronews, rubrique hi-tech http://bit.ly/12iDC8h
Renouvellement du label Lyon ville équitable et durable
http://bit.ly/Rwv5F9
DotRiver, membre du consortium "nuage-France" http://bit.ly/LNIfMr

Pas à pas, agissons au quotidien pour préserver notre environnement.
N'imprimez que si nécessaire, réduisez vos déchets informatiques,
économisez l'énergie en utilisant les solutions DotRiver.


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted