I have Query ” qtyTransactionDetails" comes from 3 tables(tblItems, tblTransactionsItems and tblTransactions).
Can I add a calculated field shows "net quantity", which is = tblItems. Strart_RetailUnit_Qty + (tblTransactionsItems. Quantity_Retail where tblTransactions.TransType=1 ) - (tblTransactionsItems. Quantity_Retail where tblTransactions.TransType=2 )
Please see the attached database -Inventory-be---EE.accdb
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening. This article shows how to create and use them.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc.
In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another.
Base the dependent combo on a query for its row source:
Add a reference to the first combo on the form as criteria i…