[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
joudiabouraied
Newbie

Joined: 02 Feb 2009
Posts: 3
Location: Saudi Arabia

 Posted: Mon Feb 02, 2009 4:04 am    Post subject: Simple inventroy database 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
Super User

Joined: 24 Apr 2008
Posts: 2696
Location: Apeldoorn, Netherland

 Posted: Mon Feb 02, 2009 5:44 am    Post subject: 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
Newbie

Joined: 02 Feb 2009
Posts: 3
Location: Saudi Arabia

 Posted: Mon Feb 02, 2009 10:26 am    Post subject: 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
Super User

Joined: 24 Apr 2008
Posts: 2696
Location: Apeldoorn, Netherland

 Posted: Mon Feb 02, 2009 12:13 pm    Post subject: 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
Newbie

Joined: 02 Feb 2009
Posts: 3
Location: Saudi Arabia

 Posted: Mon Feb 02, 2009 2:07 pm    Post subject: Thanks Thank you Sir very much for your cooperation, hope i didn't bother you
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum