Results 1 to 2 of 2
  1. #1
    rochy81 is offline Novice
    Windows Vista Access 2007
    Join Date
    Sep 2008

    Database Help On Comparing Incoming and Outgoing Material


    I need to create a database that compares quantities. We have a certain number of parts that come in overseas that we have to re-ship out to other customers. However, we need to compare those two incoming and outgoing quantities of each part number.

    I have a sample of what i need it to look like in the screenshot that's attached to this thread. Can someone help? I created a simple database with tables and some queries but i dont really know how to go about doing this.

    So basically, i want to search a part number and it will display in and out quantities according to dates.

    Not sure if that made sense but please help me, I can explain further if needed.

    Been trying to work on a solution for this. Still very new to Access but it's been a learning process and I have been learning a lot.

  2. #2
    rochy81 is offline Novice
    Windows Vista Access 2007
    Join Date
    Sep 2008
    as you can see in that screen shot, I counted how many quantity for that part that came into our warehouse. For example, between the dates of 4/7/08 to 4/10/08, we had a total of 5400 pcs come in. On 4/22/08, 5000pcs was sent to our customer so 400pcs carried over to our next shipment 5/21/08.

    It doesn't have to be that complicated. I actually just want something similar to this where i can see a side by side comparison of the quantities coming in and going out. The access database doesnt have to count what carried over or not.

    Thanks again for your help/advice

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

Similar Threads

  1. Help On Comparing Quantity in Tables
    By rochy81 in forum Access
    Replies: 2
    Last Post: 05-29-2009, 10:20 AM
  2. Comparing Part Quantities According to Dates
    By rochy81 in forum Reports
    Replies: 6
    Last Post: 05-19-2009, 09:11 AM
  3. Comparing between fields
    By Dashin in forum Queries
    Replies: 0
    Last Post: 02-13-2009, 08: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