Search results

I checked the Query is good ,thank you but the sort is not correct if i filter yarn and the yarn have transaction with different dates,so i will try to create an open book for every record to get right sort , thank you my friend for you help.

Query name "TransactionDataBalanceQ"

If you have time i can send you the Database it will more easier for you??

Thank you for your replay, I use your SQL Statement the result some how messing something bcz it show me : as you see the first two record are positive so it must plus and the balance must be 190!!! Could you solve this problem ?

You are right , thank you

Hello.... I am trying to create a query statement in access to show the current stock balance like a tree ,I use a subquery to get the current balance with this SQL statement : SELECT TransactionDataTotalBalance.TransID, TransactionDataTotalBalance.TransDate...

I have been working with Microsoft Access for 2 years and I created many tables ,Queries, Forms ,Reports ,Created an inventory transaction with barcode and stock by using VB codes. I live in Turkey , And I hope to learn more about SQL and VB Functions and also be useful to use my experience to...

Hello.... I am trying to create a query statement in access to show the current stock balance like a tree ,I use a subquery to get the current balance with this SQL statement : SELECT TransactionDataTotalBalance.TransID, TransactionDataTotalBalance.TransDate...