Results 1 to 12 of 12

Thread: Stock Problem

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Jan 2006
    Location
    PUNE
    Posts
    222

    Stock Problem

    am developing Application VB and Access
    i have 3 tables
    Item_desc_local
    Item_desc_outward
    Stock_master

    In Item_Desc_local am Having Quantity is Received
    In Item_desc_outward Qty is Dispatched
    In Stock MAster am Having Opening BAlance For Every Item
    Then Qty_received & Qty_dispatched


    Problem :

    I Wants to Take Sum of Quantity Received For Each Item in Item_desc_local For Item_desc Unique Item_code i have assigned

    I Wants to Take Sum of Quantity Dispatched For Each Item in Item_desc_Outward For Item_desc Unique Item_code i have assigned

    I Want to calculate Balance Qty For Each Item

    How can i Go

    Thanks

  2. #2
    Hyperactive Member binilmb's Avatar
    Join Date
    Nov 2005
    Location
    Kochi
    Posts
    472

    Re: Stock Problem

    Post the Structure of those three Tables
    įňįl

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Jan 2006
    Location
    PUNE
    Posts
    222

    Re: Stock Problem

    am Sending the Structure
    wait

  4. #4

    Thread Starter
    Addicted Member
    Join Date
    Jan 2006
    Location
    PUNE
    Posts
    222

    Re: Stock Problem

    am Sending Access TAble Structure

    Thanks
    Attached Files Attached Files

  5. #5

    Thread Starter
    Addicted Member
    Join Date
    Jan 2006
    Location
    PUNE
    Posts
    222

    Re: Stock Problem

    Can anyone guide me on This Issue

    Thanks

  6. #6
    VB Guru ganeshmoorthy's Avatar
    Join Date
    Dec 2005
    Location
    Sharjah, United Arab Emirates
    Posts
    3,031

    Re: Stock Problem

    vaishali: I dont have the option to open attachements in my office, if you dont mind send it to my mail id, i'll check it out...
    If an answer to your question has been helpful, then please, Rate it!

    Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.


  7. #7
    Addicted Member girl81's Avatar
    Join Date
    Apr 2006
    Location
    Malaysia
    Posts
    211

    Re: Stock Problem

    hi everybody
    i'm also make a stock program like Vaishali.

    i'm also don't know how to calculate in VB.What i did now is...In order to get the balance and total of quantity, i just count and generate it in Query (Access).So that if i add or deduct an item during runtime (VB), it just generate from Access.

    So hope anybody can help me if there are any better way.
    tq

  8. #8
    PowerPoster
    Join Date
    Feb 2006
    Location
    East of NYC, USA
    Posts
    5,692

    Re: Stock Problem

    TotalQuantity = OldQuantity - QuantitySubtracted
    and
    TotalQuantity = OldQuantity + QuantityAdded
    The most difficult part of developing a program is understanding the problem.
    The second most difficult part is deciding how you're going to solve the problem.
    Actually writing the program (translating your solution into some computer language) is the easiest part.

    Please indent your code and use [HIGHLIGHT="VB"] [/HIGHLIGHT] tags around it to make it easier to read.

    Please Help Us To Save Ana

  9. #9
    Addicted Member girl81's Avatar
    Join Date
    Apr 2006
    Location
    Malaysia
    Posts
    211

    Re: Stock Problem

    tq i will try it out...and i will tell u the result

  10. #10
    Hyperactive Member binilmb's Avatar
    Join Date
    Nov 2005
    Location
    Kochi
    Posts
    472

    Re: Stock Problem

    Sql to Sum of Quantity Received For Each Item in Item_desc_local is

    SELECT item_cat, sum(qty_rcvd) AS rsum FROM item_desc_local GROUP BY item_cat;

    Sql to Sum of Quantity Dispatched For Each Item in Item_desc_Outward is

    SELECT Item_category, Sum(Issue_qty) AS SIss FROM outward_item_desc GROUP BY Item_category;
    įňįl

  11. #11

    Thread Starter
    Addicted Member
    Join Date
    Jan 2006
    Location
    PUNE
    Posts
    222

    Re: Stock Problem

    Actually i wants to calculate sum for Same Item_code

    Thanks

  12. #12
    Hyperactive Member binilmb's Avatar
    Join Date
    Nov 2005
    Location
    Kochi
    Posts
    472

    Re: Stock Problem

    Then replace the item category in the sql to Item_code
    įňįl

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width