Jean Hollis Weber wrote:
Shane Johnson wrote:
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.
I'm not sure which how-to you are referring to, so the one I'll give
here may be the same one. I'm also not sure if it covers what you need
to know. I have not used Base enough myself to say much more than that.
Getting Started with Base,
http://documentation.openoffice.org/manuals/oooauthors2/0110GS-GettingStartedWithBase.pdf
Regards, Jean
Jean Hollis Weber
[EMAIL PROTECTED]
It's not the one I read. I appreciate the link. Unfortunately it
doesn't tell me how to do what I need to do.
This is one of the formulas out of one of my queries in Access....
Descr:
IIf(Len([BoManuals]![Desc])>20,Left([BoManuals]![Desc],20),[BoManuals]![Desc]+Space(20-Len([BoManuals]![Desc])))
This would label my column Descr and then fill it according to the
length of [BoManuals]![Desc]. (It would either cut it off at 20
characters or fill in spaces after the data if it was too short.) This
is the sort of thing I am trying to do with Base and am not finding out
how to accomplish it.
Thanks
Shane
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
