Results 1 to 4 of 4
  1. #1
    Vanz is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2021
    Posts
    12

    Display onhandqty on form


    Dear All,


    I have created a inventory database with all the tables and form completed, however i have trouble displaying the onhandqty on the form.

    my idea would be once i selected the product category on the form, it will automatically show me the onhandqty balance on my issue form so that it will prevent me form issuing materials more than what i instore. I have attached my sample database above. Any help is appreciate!! thank you all. Sample Inventory.zip

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Generally you just sum, what comes in and what goes out?
    What goes out is generally a negative value?
    Amounts should be in the same field, so a simple sum works. DSum() perhaps ?

    Edit: I managed to open your DB, but could not see what form you are talking about.
    Your structure looks highly incorrect?, what is the number of stores increases to 10, 20, 30?

    You should have one table for each and a field to indicate which store.?
    You would not have a table for each product?, the same applies to stores.

    Also generally you should not store anything you can calculate on the fly, like Total amount

    So in your case in the state the DB is in at the moment, use Dsum() to get QuantityReceived and IssueQuantity for a product (no naming consistency here?) and subtract one from the other. Not sure if you should also deduct RejectedQuantity as well?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  4. #4
    Vanz is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2021
    Posts
    12
    thanks all

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

Similar Threads

  1. Replies: 2
    Last Post: 01-26-2021, 06:44 PM
  2. Replies: 3
    Last Post: 01-05-2016, 12:25 PM
  3. Replies: 3
    Last Post: 10-28-2015, 12:38 PM
  4. Replies: 3
    Last Post: 03-17-2014, 10:23 AM
  5. Replies: 5
    Last Post: 11-01-2012, 09:26 AM

Tags for this Thread

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