Wow !! I'm for sure impressed by the speed and the accuracy of your
helping hint. I'll try it out asap and let you know.
Have a nice evening (I'm GMT +2)
Regards
A.Muller
Dan Lewis a écrit :
Before making blanket statements about Base documentation like you did,
you should pay closer attention to the facts. Specifically, have you read
Getting Started with Base? It is a part of the Getting Started Guide.
http://documentation.openoffice.org/manuals/oooauthors2/
Base is a relational database. This means it consists of tables. Every
one of those tables can be used to create a form. And when I speak of
tables, I am referring to those listed under the "Tables" category
including Views as well as queries. That means a form can be created from
a query.
Example of what you want: Table 1 contains Field A. Create a new query
in design view (see above documentation if necessary). Add Table 1 to the
query and open a window containing the fields of Table 1. Double click
Field A in that window to place it in a field of the query. Click inside
that field and add + "integer" to the right of Field A in that field:
Field A + "integer". (Use whatever integer you want in place of "integer".)
Run the query. The values for the field you just created will be larger
than the corresponding values of Field A by the integer you used. Save the
query.
Then create a form using the wizard. The query you just created will be
listed in the Tables or queries dropdown list.
Dan
On Thursday October 18 2007 05:27 am, A.Muller wrote:
Thanks for the kind answer. I would like to place this calculated field
in a form.
Thanks for helping
A.Muller
Mechtilde Stehmann a écrit :
Hello,
A.Muller schrieb:
Hello everybody!!
I have written a couple of times to this forum without getting any
answer ; apparently nobody gives a **** about Base. OK, I recognize
all answers are given by people who volunteer to help, so maybe no
one has a good Base knowledge.
It is right. there are only few peole who work with the base modul and
have the experience with it.
<snipp/>
OK, now back to me : how can I create a calculated field in Base ?
Quite a simple one, it would be "field A + an integer = field B". I
read all the documentation of the OO site without finding an answer.
Thanks for the attention.
Where do you want to create the field?
Base is a container for many informations around a database.
You can use it in a query, in a form, and in a report.
Regards
Mechtilde
---------------------------------------------------------------------
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]
