Search results

Hello, I need help creating a query that will out put the short date when you take into account the on hand inventory minus the usage plus the deliveries. Thanks to arnelgp with helping on finding the stock out date when I take the on hand inventory minus the usage but now I need to add in the...

Hello, The date output needs to be when all the current quantity is used. So Item 548-542 currently has qty. 5 Therefore,4/6/18, 4/16/18, 4/24/18, 5/2/18, This uses all the current quantity so 5/10/18 it the date that needs to be shown. 548-542 4/6/18 1 548-542 4/16/18 2 548-542 4/24/18 1...

Hello, I am trying to crate a query that will provide an output row with the part number and the short date. Query 1 Has the part number/ usage date / usage qty Query 2 Has part number / on hand inventory Example Item. Usage date. Qty. used 548-542 4/6/2018 1...

Hello, I am fairly new to access and thought that this would be a great place to pick up some knowledge. I can build some simple queries but where I havr difficulties is with the expressions. On my free time I manage and play on a paint ball team. Thanks in advance for all the help. Josh