Simple inventroy database

[joudiabouraied]

HI,
i just started to use oobase, and i want to make small database to perform inventory of my stocks. i know how to do it in MS access, but not yet in OO! i can my tables and forms, but i need to make a formula to calculate the value of my stocks something like: sum(item price*quantity). this function is available in MS acess, but i didn't know how to make it in OO base.
Thnks for any response.

[RPG]

Hello

Your question is not clear to me. I understand you want do something with OOobase and special with the select function and sum.

If you search on this forum
on sum and sliderule you will find several post what maybe will help you

I add two links
http://www.oooforum.org/forum/viewtopic.phtml?t=74401&highlight=sum
http://www.oooforum.org/forum/viewtopic.phtml?t=73963&highlight=sum

I hope this help you with finding what you need.
Romke

[joudiabouraied]

sorry, i'll try to make it clear:
in MS access: i'll make table contains: ID, item name, unit price, quantity.
then i'll creat form based on this table> in this form i'll add one blank field and open properties and in control source i'll type:
=[unit price]*[quantity]
it means unit price multiply quantity ,this will give me the total value of one item.
if i want to get the grand total of the stock i'll copy the new field and ulter the formula to:
sum([unit price]*[quantity]). this will give me the total amount of all items.

can OO base do that?
hope its clear enough.
thanks for help.

[RPG]

Hello

I'm willing to give you an answer but it is outside my capabilities.
I can only point you to other persons.

Villeroy and Voobase tell every week sometimes more the same story.
For every beginner it is important to read it.

http://www.oooforum.org/forum/viewtopic.phtml?t=79489
http://www.oooforum.org/forum/viewtopic.phtml?t=79425&view=previous

I can give you an answers on your question: Can you make a form with totals: no

Villeroy answers in same the question is in this link
http://user.services.openoffice.org/en/forum/viewtopic.php?f=13&t=15000.

If you want make forms read this manual
http://www.geocities.com/rbenitez22
and
http://sheepdogguides.com/fdb/fdb1main.htm

The answer on the question if OOo can do it is also outside my capabilities and depends also of how big is your inventory.
You must understand I'm only a home user.

Romke

[joudiabouraied]

Thank you Sir very much for your cooperation, hope i didn't bother you