Access is quite new to me,but now i hope i can start learn it.
I am creating a DB that need to keep track of my Quantity of hand(QoH).
I need a query that calculates the QoH.
My DB have two transaction type,one is receive (add QoH) and one is Issue Out (Minus QoH).
Then each transaction have Receive from User,Receive from vendor, and Issue to user, and Issue to Vendor.
Can i do a calculation by select all four table together?
Like example
At Form 1,QoH = 3
ReceiveFromUser = 2
Then QoH will Show 5 after i click Save Button.
Then i go to Form 2
QoH will Show 5 automatically
Then i key in IssueToVendor = 4
Then QoH will Show 1 after i click Save Button.
Can this happen in query?
Because i know query can do this Total: [Qty]*[Price]
but i don't know How it do my DB QoH because my QoH value depend on 4 input of quantity.
I hope i can get somebody to tell me,thanks a lot.
I am creating a DB that need to keep track of my Quantity of hand(QoH).
I need a query that calculates the QoH.
My DB have two transaction type,one is receive (add QoH) and one is Issue Out (Minus QoH).
Then each transaction have Receive from User,Receive from vendor, and Issue to user, and Issue to Vendor.
Can i do a calculation by select all four table together?
Like example
At Form 1,QoH = 3
ReceiveFromUser = 2
Then QoH will Show 5 after i click Save Button.
Then i go to Form 2
QoH will Show 5 automatically
Then i key in IssueToVendor = 4
Then QoH will Show 1 after i click Save Button.
Can this happen in query?
Because i know query can do this Total: [Qty]*[Price]
but i don't know How it do my DB QoH because my QoH value depend on 4 input of quantity.
I hope i can get somebody to tell me,thanks a lot.
