Results 1 to 3 of 3
  1. #1
    rmbohra is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2013
    Posts
    1

    Calcuation Confusion Pls Help

    I have created queries from Incoming Raw Material and Out Going Raw material Tables



    Now how to get balance Stock of Item wise,

    My Query Look as under
    item wt In Coils Out Coils Wt Bala Stock
    part A 100 kg 10 3 30 Kg 7
    part A 100 kg 10 5 30 Kg 5

    I want that Balance Stock shall be 2 Coils of Part A , How shall I get the same result.

    Pls Help/

    Rajesh

  2. #2
    A S MANN is offline Advanced System Analyst
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    India
    Posts
    164
    Some clerification
    In Coils Out Coils Bala Stock
    10 3 7
    10 5 5
    Your balance is 7 + 5 = 12
    What do you mean by
    I want that Balance Stock shall be 2 Coils of Part A , How shall I get the same result
    Calculation are simple but let me understand it fully.

  3. #3
    Demerit's Avatar
    Demerit is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Nov 2013
    Posts
    125
    For Part A, 10-7 = 3 So what do you mean by 2 coils?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. DLL Confusion
    By frankvfox in forum Access
    Replies: 6
    Last Post: 08-11-2013, 07:22 AM
  2. Rounding a calcuation
    By crowegreg in forum Forms
    Replies: 3
    Last Post: 08-14-2012, 12:30 PM
  3. Block IF End IF Confusion
    By Phred in forum Programming
    Replies: 11
    Last Post: 03-10-2012, 02:18 PM
  4. VB and SQL confusion
    By Wayne311 in forum Programming
    Replies: 29
    Last Post: 01-31-2011, 10:27 PM
  5. Confusion
    By colenzo in forum Access
    Replies: 4
    Last Post: 07-21-2009, 06:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums